Press "Enter" to skip to content

Removing Leading or Trailing Zeroes with Power Query

Nicky van Vroenhoven wants to clean up some text:

Just before the holidays start, I’d like to share this little trick I came across in Power Query.

I recently had the need to remove zeroes (but it can be any character) from the beginning of a column.
Turns out there’s a perfect function for that 🙂

Click through to learn what this function is and how it works.