=RIGHT(A1,5)
--
Gary''s Student


"RISXRAY" wrote:

I'm trying to make a 9 digit number a 5 digit number by removing the first
four numbers. I have several lines of data and would like to do this in one
or two steps.

Example: 123456789 to end up looking like 56789