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

--
HTH,
Bernie
MS Excel MVP


"Ed H" <Ed wrote in message
...
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.