I have a column of alphanumeric tracking numbers set to text. There are leading zeros and I would like create a new column that does not include the leading zeros. The tacking numbers cover various formats and length so there is no consistent amount of leading zeros. Any guidance would be greatly appreciated.
1 ACCEPTED SOLUTION
@CNENFRNL has provided an elegant solution to your request.
Here is a useful post should your scenario get more complex. [https://www.excelguru.ca/blog/2015/11/19/keep-only-numbers-in-power-query/]
| Have I solved your problem? Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;). |
| If you found this post helpful, please give Kudos. It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen. If you find my signature vaguely amusing, please give Kudos. |
Proud to be a Super User!
Helpful resources
Power BI Monthly Update - September 2025
Check out the September 2025 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
