| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
last 4 of ss#s
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
last 4 of ss#s
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
