Power Query: Extract Numbers from a Text String

---

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

---

Reuse your Power Query work

Build on this text-cleaning technique with reusable Power Query transformation patterns.

View Power Query Toolkit

Need help adapting this to your data? Discuss your project.