Cleansing Special Characters

[LucasHolliman]

I am working on this Excel sheet for which I have to cleans the Item data. How would I go about removing all special characters from the data in column D with a dynamic function?

[#2]

You mean not by using control+H ? Check out the SUBSTITUTE function.