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