Greetings,
I'm looking fo an array formula to substitue specified charasters with an
underscore. I've tried:
=SUBSTITUTE(MyRange,{" ","&","(",")"},{"_","_","_","_"}) Ctrl+Shift+Enter
This works for any instances of the first character (space) but ignores any
of the others.
Any advice will be appreciated
TIA
--
David