Thread
:
SSN Format
View Single Post
#
3
Dave O
Posts: n/a
SSN Format
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.
Reply With Quote