formula or macro? whichever, I need help

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

Guest

I have a cell/column with 9-digit social security numbers, no spaces, no
dashes. I need the last 4 numbers of each cell copied into a seperate
cell/column. I can't find anything about copying partial cell value. Can
anyone please help? Thank you,
Dagmar Livingston, Columbus, GA
 
Dagmar

Assume 123456789 in A1

In B1 enter =RIGHT(A1,4) to return 6789


Gord Dibben MS Excel MVP
 
Back
Top