Avatar of mkramer777
Flag for United States of America

asked on 

excel - adding x's to social security number

I have an excel sheet that has names and social security numbers.  I need to update all of the ss #'s to show the number like this:   xxx-98-9744.  The first 3 digits need to be x's.  Any ideas on a formula that I could copy to do this?  I'm not very proficient with excel so I will also need  instructions on how to copy this through the column so each number gets changed correctly.
Microsoft Excel

Avatar of undefined
Last Comment
Rob Henson

8/22/2022 - Mon