The formula above replaces an ampersand in a cell where I have the text
Handy Person / Driver & Car
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?