Power Query: Extract Numbers from a Text String

---

Check out some of our FREE templates and materials.

Join newsletter

PRACTICE MATERIAL BELOW!👇

---

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 nullable text) as nullable text =>

let

NumbersOnly =

if inputText = null then null

else 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