assuming that you are only interested in a few known final digits you can use the "right" statement to strip the final text characters.
For example - if your names list is in collumn B, you can put the followig in cell C
n "=RIGHT(Bn,2)" and it will give just the last two letters of B
n.
Got that?