How do I mask a Social Security Number ###-##-nnnn?

  • Thread starter Thread starter Ed H
  • Start date Start date
E

Ed H

I am doing verification forms and it includes ss#. Because of identify
thief, I want to mask all of it except for the last four digits. I am using
a spreadsheet as my database. I have the ss# entered in one column and would
like to set the next column with the masked number.
 
Ed,

With the SSN in A2:

="###-##-" & RIGHT(A2,4)

But then, if you don't really need the SSN, copy the formulas, paste values, then delete the
original SSN
 
And to add to Bernie's warning...

Don't include the SSN's in any workbook you share with others--even if you put
them in a hidden column or a hidden worksheet.

Excel's protection isn't made for protecting this kind of thing. It's made to
stop inadvertent typing errors (stopping people from overwriting a formula).
 
Back
Top