Power Query: Extract Numbers from a Text String

Function: Extracts only the numeric values from a given text. Simply add custom function in Power Query and define your column.

Add a new Query from Sources

Usage:

 = ExtractNumbers("Order ID: 123ABC456") → Returns: "123456"

Power Query code for use and reuse:

let

    ExtractNumbers = (inputText as text) as text =>

    let

        NumbersOnly = Text.Select(inputText, {"0".."9"})

    in

        NumbersOnly

in

    ExtractNumbers

Choose your column with a text/number to clean (to extract just numbers)

Need a code and instructions? Free of charge =)

pq_ExtractNumbersFromString.txt

Download TXT • 1KB