Remove the hypens from a social security number

J

JudithJubilee

Try

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

where the number is in cell A1

Judith
 
P

Peo Sjoblom

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Removing hypen from existing text 2
Adding hyphen to text in cell 6
date input mask 1
REPLACE command drops leading zeros 4
Removing text between hyphens and removing the hyphens 8
Adding a HYPHEN to a 9 digit zip code column 7
Microsoft.Jet.OLEDB error with csv file names 0
Using REPLACE command removes leading zeros 2

Top