Hi David

Try using the non-array entered
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(myRan ge,"
","_"),"&","_"),"(","_"),")","_")

Regards

Roger Govier


David wrote:
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