Remove or Extract Special Characters Using Power Query
Power Query’s Text.Select keeps only the characters you list, and Text.Remove throws them away. With one custom column you can strip !@#$%&* from messy text, or pull out just the numbers, capitals or letters. FunctionsText.Select, Text.Remove Works inExcel 2016 and later, Microsoft 365 RefreshableYes The data Step 1: Load the data into Power Query Click … Read more