For each row - read only last 5 numeric characters

so my data item would be in the format “XXXXXXXY”

where X= numeric
and Y = alphanumeric

it is the “Y” I wish to remove ignore