Formula to remove dashes

[howard]

I have the following text in cell A12 & need to remove the dashes "-"

A971-251-9751

I can remove these by entering a formula into seperate cells as follows:

=FIND("-",A12)
=FIND("-",A12,B12+1)
=LEFT(A12,B12-1)
=MID(A12,B12+1,C12-B12-1)
=RIGHT(A12,LEN(A12)-C12)

I would like one formula that will do the trick

 

[Aladin Akyurek]

I have the following text in cell A12 & need to remove the dashes "-"

A971-251-9751

I can remove these by entering a formula into seperate cells as follows:

=FIND("-",A12)
=FIND("-",A12,B12+1)
=LEFT(A12,B12-1)
=MID(A12,B12+1,C12-B12-1)
=RIGHT(A12,LEN(A12)-C12)

I would like one formula that will do the trick

Try...

B12:

=SUBSTITUTE(A12,"-","")

 

[howard]

Hi Aladin

Thanks for the help, much appreciated

Regards

Howard

 

[Aladin Akyurek]

Hi Aladin

Thanks for the help, much appreciated

Regards

Howard

You are welcome. Thanks for providing feedback.