Peo, Pete, Ron
Thanks for your help. That makes what I want to do much easier. Otto
"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