Is there a way to short this substitute formula?
 

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

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


--
Wag more, bark less

Is there a way to short this substitute formula?
 

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.


--
Biff
Microsoft Excel MVP


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

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


--
Wag more, bark less

Is there a way to short this substitute formula?
 

Thanks.
--
Wag more, bark less


"T. Valko" wrote:

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.


--
Biff
Microsoft Excel MVP


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

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


--
Wag more, bark less

Is there a way to short this substitute formula?
 

You're welcome!

--
Biff
Microsoft Excel MVP


"Brad" wrote in message
...
Thanks.
--
Wag more, bark less


"T. Valko" wrote:

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.


--
Biff
Microsoft Excel MVP


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

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


--
Wag more, bark less