I am working on a spreadsheet that needs to be mail merged onto a word doc. Part of what I am merging is SSN's. I do not want to put all 9 digits, just the last 4. I have them entered into the spreadsheet as xxx-xx-xxxx. What type of formula do I write to remove the xxx-xx from the cell so I can mail merge these digits into a word doc.

It is quite easy, suppose you have 14 digit numbers like ABCDE123456789 in cell[ A1], from which you can extract the last nine digits with the formula as below

=VALUE(RIGHT(A1,LEN(A1)-5)

Otherwise, if the number looks like 123456789ABCDE then the fornula

=VALUE(LEFT(A1,LEN(A1)-5) will do the trick.

Else if your number looks like ABC123456789DE then also, the formula

=VALUE(MID(A1,4,LEN(A1)-5) will work.

Does this answer your question? If not, please feel free to ask your specific question related to the problem

Vikram S. Mathur