last 4 of ss#s

  • Thread starter Teacher in Korea
  • Start date
T

Teacher in Korea

I need to pull the last 4 numbers from SS#s that I've imported into excel so
they can be used as beginning passwords for students. The list is several
thousand long and I'd like to automate the process. The initial cell with
ssan is formatted as custom 000000000 so I don't lose leading zeroes. Any
help will be appreciated.

Jesse
 
M

Max

One way ..
Assume source data in A2 down
In B2: =TEXT(RIGHT(A2,4),"0000")
Copy down
 
Top