Converting numbers with dashes

[Chevy Nick]

Hello,

I have a spreadsheet with numbers that were entered with dashes, ie. 1111-22-333-4444

I would like to convert this to just a straight number that excel will recognize and work with, ie 1111223334444

I have attached a small example.

Thank you for your help

[sweep]

Hi,

=VALUE(SUBSTITUTE(A3,"-",""))

and copy down should do it.

[Ron Coderre]

Using your posted workbook...try this:

C3: =--SUBSTITUTE(A3,"-","")

Copy that formula down as far as you need.
If you need numbers, and not formulas...
Copy the formula range and Home.Paste.Paste_Values

Note: The double-minus coerces the numeric text into actual numbers.

Is that something you can work with?

[Chevy Nick]

It worked beautifully, thanks for your help