Press "Enter" to skip to content

Extracting Letters from a String in Power Query

Published 2021-01-19 by Kevin Feasel

Imke Feldmann shows us how to get just the letters (and not numbers or symbols) from a string using Power Query:

Image you have a string like so: “10.ROADBIKES.423/01” and would like to extract only “ROADBIKES”.
Power Query actually has a function for this purpose:

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

Published in Power BI