Press "Enter" to skip to content

Extracting Letters from a String in Power Query

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.