format social security number

G

Guest

I am trying to figure out how to format a social security number. When I pull
data from our system, it comes in as xxx-xx-xxxx. I need to drop the first 5
numbers of the social security number so it looks like xxxx. Can someone help
me?
 
G

Guest

Thank you so much! I also have another formatting question. I need to be able
to format a cell so I can get just the first initial and last name of a
person. Right now the data is formatted with the last name in one cell and
the first anme in the other. How would I get it to read first initial, last
name?
 

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

Excel VBA to move cursor from 1 cell to another, once original cell is filled with data. 3
Cell Format 3
Format Cells - Custom 1
Calculating Social Security 3
Time punch data from rows to columns 3
Masking a field in Report only 2
How do I calculate age using a 12 digit social security number in MS Excel? 0
Social Security Number format 1

Top