replace last four of ssn with xxxx
how about: =left(a1,7)&"xxxx"
"mary s" wrote:
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?
|