I have a sequence of numbers like 08123, 0912345, and 0712. The first two are the year and the next numbers is just a counter that adds one each time data is entered. I now need to seperate the years from the numbers, but the last digits can have two digits, three digits or more. I have tried left(str) and right(str). I know it must be a combination of the two.

Thanks for any help.

try

mid(str,3)

Wow. so simple and it works. Thank you!