Remove the hypens from a social security number
 

I just want to display the numbers without hypens, is there a formula?

Remove the hypens from a social security number
 

Try

=left(A1,3)&mid(A1,5,2)&right(A1,4)

where the number is in cell A1

Judith
--
Hope this helps


"Geish" wrote:

I just want to display the numbers without hypens, is there a formula?

Remove the hypens from a social security number
 

If they are numbers formatted as SSN then just use

000000000

custom format, if they are text then just press ctrl + h and replace - with
nothing


--
Regards,

Peo Sjoblom



"Geish" wrote in message
...
I just want to display the numbers without hypens, is there a formula?