Show alternate or different characters

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a column that contains Social Security numbers. I would like this
column to display the numbers as 'xxx-xx-1234'. I can't seem to be able to
figure out how to do this. Cell formatting doesn't tell really say about a
'replacement' character.
 
Try using a formula in the adjacent column and then hiding the original
column. Assuming the SSN are in col. A:

="XXX-XX-"&RIGHT(A1,4)

HTH
Jason
Atlanta, GA
 
Back
Top