replace multiple characters at different places in a string Excel 2007
- by conspirisi
=SUBSTITUTE(AD!H35,"&","")
The formula above replaces an ampersand in a cell where I have the text
Handy Person / Driver & Car
giving
Handy Person / Driver Car
How do I also remove the forward slash '/' ?
I've seen it done with nested substitute formulas, but as I probably need to remove even more characters in the future. I'd rather use a more elegant solution. Perhaps even replacing an entire class of non-alphanumeric characters is another solution?