Two Substitutions in a Single Formula [SOLVED]

[dparteka]

Cell A1 has this in it… XZY: 12-345-678-900. I want to use the =SUBSTITUTE function in cell B2 to output the same text as A1 but without dashes and spaces XZY:12345678900. I have been able to eliminate the space and dash individually but have not figured out how to do both in a single formula… can anyone help me?

 

[Faseeh]

Hi dparteka,


Try this:

=SUBSTITUTE(SUBSTITUTE(A1,"-","")," ","")

With A1 containing text.


Regards,

 

[dparteka]

Faseeh, you make that look too easy, thanks for doing your magic, it works perfectly... best regards...Dennis

 

[Faseeh]

You are welcome dparteka!