ExcelBanter - last 4 of ss#s

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - last 4 of ss#s (https://www.excelbanter.com/excel-discussion-misc-queries/137480-last-4-ss-s.html)

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

One way ..
Assume source data in A2 down
In B2: =TEXT(RIGHT(A2,4),"0000")
Copy down
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Teacher in Korea" wrote:
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