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

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

Bernie Deitrick

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
 
D

Dave Peterson

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

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
How do I sum here using criteria there? 10
Hiding part of a Social Security Number 1
How do I mask SOME characters in a field in Access 2007? 3
Input mask problem 33
format social security number 2
How do I convert nnnnnnnnnn to nnn nnn nnnn (Telephone numbers)? 5

Top