format social security number
 

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?

Format the cell (say A1) containing the SS number as text. Then use

=RIGHT(A1,4)
--
Gary''s Student


"Kristy" wrote:

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?

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?

"Gary''s Student" wrote:

Format the cell (say A1) containing the SS number as text. Then use

=RIGHT(A1,4)
--
Gary''s Student


"Kristy" wrote:

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?