Download the featured file here: https://www.bluepecantraining.com/wp-content/uploads/2023/07/Remove-Special-Characters-Using-REDUCE.xlsx

If you don't have the REDUCE function in your version of Excel, see my video that uses Power Query to remove special characters: https://youtu.be/8POlb547SDQ

In this Microsoft Excel video tutorial I demonstrate how to remove special characters {~#&}|@*%$ or any series of characters from a text string. I use the REDUCE function together with LAMBDA and SUBSTITUTE to achieve this.



#exceltutorial #exceltips #excel365