SSN Format

D

Dave O

How about a search and replace? Search for the dash and replace with
nothing. Or, you could use a couple of text parsing functions in a
formula:
=left(A1,3)&mid(A1,4,2)&right(A1,4)
.... where A1 contains the SSN.
 
D

Dave Peterson

How about selecting the range.
Edit|replace
what: - (hyphen)
with: (leave blank)
replace all

Then give it a nice custom format: 000000000
 
N

NH

Thanks so much for your very helpful suggestion.

Dave Peterson said:
How about selecting the range.
Edit|replace
what: - (hyphen)
with: (leave blank)
replace all

Then give it a nice custom format: 000000000
Click to expand...
 

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

07 Pivot Table side by side row labels 3
Some of my SSN's are being treated as formulas 12
Masking Characters 6
Copying SSNs to new format 6
How do I create an Access form that blocks 1st 5 #s of SSN? 1
Merge field formatting question 1
Format MERGEFIELDs as telephone # and SSN # 2
Finding Text String Within A String With A Formula 5

Top