Formula to strip "-" from ID Number

[3345james]

Looking for a formula - or Conditional formatting that will take ID as seen in Col A and remove "-" so looks like col B

ID Final Result Formula to make A:A,B:B
123-45-6789-123 123456789123
234-56-7891-112 234567891112
123-45-6789-124 123456789124
234-56-7891-113 234567891113
123-45-6789-125 123456789125
234-56-7891-114 234567891114

I've attached excel file

Thanks in Advance for an assist
Jim

[AlKey]

Enter formula in B2 and copy down

Please Login or Register  to view this content.

[Tony Valko]

This formula entered in B2:

=--SUBSTITUTE(A2,"-","")

Format as Number, 0 decimal places

Copy down as needed

[3345james]

Thank you so much - again!
We don't use SUBSTITUTE very often in our area - good formula to add to the quiver.

Thank
Jim

[3345james]

Thanks my friend
This works great - what does the +0 mean at the end?

Appreciate the assitance
Jim

[AlKey]

Thanks my friend
This works great - what does the +0 mean at the end?

Appreciate the assitance
Jim

Hi Jim since SUBSTITUTE function always return text +0 will convert text string to real numbers.