How to Mask a Social Security Number in Excel

1. Select the column that contains the Social Security Numbers that you want to mask.
2. Right-click on the selected column and choose "Format Cells" from the drop-down menu.
3. In the "Format Cells" dialog box, select the "Custom" category.
4. In the "Type" field, enter the following custom format:
   Formula:

   "###-##-0000" 

   . This format will display the first five digits of the Social Security Number as asterisks and the last four digits as plain numbers.
5. Click "OK" to apply the custom format to the selected column.

Now, the Social Security Numbers in the selected column will be masked, except for the last four digits. You can copy and paste these masked numbers into the next column to create a separate column with the masked numbers.