Power Query: Remove Special Characters from Text

---

Check out some of our FREE templates and materials.

Join newsletter

PRACTICE MATERIAL BELOW!👇

---

Function: This function, RemoveSpecialChars, cleans a text string by removing special characters, retaining only letters and numbers.

Add fx to the blank query (Advanced Editor)

Usage Example: 

Using = RemoveSpecialChars("H3ll0! W@rld#") will return "H3ll0 Wrld". The function removes specified special characters from the input text, ensuring a clean output.

Power Query code for use and reuse:

RemoveSpecialChars = (inputText as text) as text =>

let

CleanedText = Text.Remove(inputText, {"!", "@", "#", "$", "%", "^", "&", "*", "(", ")", "-", "_", "=", "+", "[", "]", "{", "}", ";", ":", "'", ",", ".", "<", ">", "/", "?", "|", "\"})

in

CleanedText

in

RemoveSpecialChars

Invoke function on desired column

This is the M-code that Power Query usually makes on every step that we do:

= Table.AddColumn(#"Added Conditional Column", "Query1", each Query1([Customer]))

Need code and instructions? Free of charge =)

pq_RemoveSpecialCharacters.txt

Download TXT • 1KB