Is there a way to short this substitute formula?

[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. 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.

 

[Brad]

Thanks.
--
Wag more, bark less

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.

 

[T. Valko]

You're welcome!

--
Biff
Microsoft Excel MVP

Thanks.