View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ed H[_2_] Ed H[_2_] is offline
external usenet poster
 
Posts: 1
Default How do I mask a Social Security Number ###-##-nnnn?

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.