Removing first two characters.

[vgersghost]

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.

 

[gemma-the-husky]

try

mid(str,3)

 

[vgersghost]

Wow. so simple and it works. Thank you!