Is there a way to short this substitute formula?

B

Brad

I want to remove all periods, hyphens and comma's. The below works but is
there a better solution?

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(K35,".","")," ",""),"-","")
 
T

T. Valko

is there a better solution?

From a formula, not really. The old_text argument can't be an array. That's
why you have to nest a new level for every different old_text argument.
 
B

Brad

Thanks.
--
Wag more, bark less


T. Valko said:
From a formula, not really. The old_text argument can't be an array. That's
why you have to nest a new level for every different old_text argument.
Click to expand...
 
Top