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).
 

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

Masking Social Security numbers 5
How do I sum here using criteria there? 10
Input mask problem 33
social security sorting 4
How do I calculate age using a 12 digit social security number in MS Excel? 0
last four digits of a social security number 2
Hide allbut last four characters of a social security number 1
Hiding part of a Social Security Number 1

Back
Top