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
 

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

Use of Wildcard characters with replace 2
Help with Conditional Formatting 5
Masking a field in Report only 2
Search text string for ssn and copy to new column 8
Show last four digits of SS# 3
How can I delete a space/character from a number of fields? 10
How do I insert hypens in existing column representing social sec. 1
Second last character incrematation 2

Back
Top