Extract Digits Only from Text in Power Query M

Notes

Useful for cleaning phone numbers or codes mixed with formatting characters before converting to a number.

Requirements

• A table with a text column containing digits mixed with other characters.

How to use this snippet

1. In Power BI Desktop, choose Transform data to open Power Query, then open the Advanced Editor on a query (or start from a blank query).
2. Paste the snippet and replace the placeholder names (tables, columns, file paths) with your own. Check the requirements above first.
3. Run it through the Power Query M Formatter to tidy the layout.

Related Power Query M snippets

• Remove Special CharactersStrips punctuation and symbols from a text column, keeping only letters, numbers and spaces.
• Standardize Phone NumbersStrips formatting from phone numbers and reformats the digits into a consistent (XXX) XXX-XXXX pattern.
• Extract Text Before / After a DelimiterSplits a text value at the first occurrence of a delimiter and keeps only the part before or after it.
• Remove Extra Spaces Between WordsCollapses repeated spaces inside a text value down to a single space, in addition to trimming the ends.
• Remove Accents from TextReplaces accented characters (é, ü, ñ, etc.) with their plain ASCII equivalents.
• Extract Text Between DelimitersPulls out the text found between two delimiters, such as text inside parentheses.

More Power Query M resources

Browse all 145 snippets in the Power Query M Code Snippets, or search the library for something similar to Extract Digits Only from Text.