double use of Substitution Function

  • Thread starter Thread starter Tonso
  • Start date Start date
T

Tonso

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
 
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
Click to expand...

Nest your functions.

A1 = hello this, is my answer
A2= =SUBSTITUTE(SUBSTITUTE(A1, " ", ""), ",", "")

HTH,
Reeza
 
Back
Top