Function: Would you like to clean multiple columns in a single operation? This custom step allows you to clean as many columns as needed. Remove extra spaces, remove non-printable/control characters, like line feeds (#(lf)), carriage returns (#(cr)), tabs, etc. Custom Column in applied steps Power Query code that you will use in the Custom Column (or inline custom step). Just reference your previous step in "Source.." (best practice is to rename steps in applied steps window,

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 => l