Excel Gurus: Need SSN function help

Status
Not open for further replies.

Seiken

In Runtime
Messages
188
I got huge reports with the SSNs containing dashes. How do I remove them without having to go through each one of them manually? I know it requires a function and formatting the entire column.

I've tried setting the column to Custom (SSN), but it's not doing anything. What's the actual function to remove the dashes?

Last, how do I add an additional digit to that formula so that all SSNs are 10-digit starting with a zero?

Any help with this is greatly appreciated! :bald:
 
=RIGHT( "0000000000" & SUBSTITUTE(A1,"-",""), 10)

or

= "0" & SUBSTITUTE(A1,"-","")
 
Status
Not open for further replies.
Back
Top Bottom