Power Query Trick: Remove Text and Leading Zeros from IDs
In this Power Query tutorial, you'll learn how to convert text-based IDs into numeric values by removing prefix characters and leading zeros.
For example:
AW00001 → 1
AW00098 → 98
AW01001 → 1001
AW80000 → 80000
This is a common data-cleaning problem when working with product IDs, customer IDs, or system-generated codes.
In this video you will learn:
How to remove leading characters
How to strip leading zeros
How to convert text values into numbers
How to perform the transformation efficiently in Power Query
This technique is very useful when preparing data for analysis, joins, or numerical calculations in Excel or Power BI.