Excelized helps turn messy data into clear dashboards and better decisions with Excel, Power BI, Power Query, Power Automate, practical training, templates, and free tools.
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"..