You will run into the nested limitations eventually but you can use more
than one substitute

spaces, commas and ampersands would look like this

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1," ",""),",",""),"&","")




--


Regards,


Peo Sjoblom




"Otto Moehrbach" wrote in message
...
Excel XP & Win XP
I am using the Substitute function in conjunction with the Indirect
function in a Data Validation formula. My question is about the
Substitute function. Is there a way to substitute nothing for more than
one thing in a single formula? For instance, substitute nothing for all
spaces, all commas, all & symbols, etc, all in one formula? Thanks for
your time. Otto