replace last four of ssn with xxxx

G

Guest

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?
 
G

Guest

Is there any way I can lock that formula so that when I copy it down a column
of SSNs the following SSNs don't change?
 
D

David Biddulph

Is there any way I can lock that formula so that when I copy it down a
column
of SSNs the following SSNs don't change?
Click to expand...

You're not copying the formula down column A, are you? If your existing
SSNs are in column A, put your formula in column B (or any convenient empty
column). If, when you've done that, you want to replace the old SSNs with
the new ones, you can cut, then paste special/ values.
 
G

Guest

Yeah. I was creating the formula and copying it down the same column. They
all work once I enter them in a new blank column and copy down. Thanks
everyone for your help!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding Text String Within A String With A Formula 5
Replace pattern of characters 5
How do I enter a SSN but only display the last four digits? 1
Only show Last Four numbers of SSN 3
HOW TO PRINT OR VIEW ONLY THE LAST FOUR OF SSN IN A FORM 1
Hide allbut last four characters of a social security number 1
Replace Comma with "-" 2
Replace Comma with "-". 1

Top