to eliminate spaces from a data validation phrase, I can enter "
=Indirect(substitute(M12," ","")" and find the named range i need
create a List.
But, suppose I need to substitute for 2 characters...space, and comma
(,). How to I write the function to do
that?

Thanks,

Tonso