How do I replace the last four of an ssn with xxxx? I tried:
Insert function
Old text A1 (or whatever start cell)
Start num 8
Num char 4
New text xxxx

The end result I want is 123-45-xxxx but every time i try to copy the
formula down it alters the successive ssns. Any ideas?