Hi raypayette, thanks for getting back to me.

The number part of the string is distinguished as they are numbers not the letters that form the start of the string. I tried to use Isnumber to evaluate the final three characters hoping that would give me a true when all three were numbers and false when it was a letter and two numbers but it resulted in false both times (I imagine because of the format).

In response to saz the case is as you fear as the number part can be two or three characters long and the letter part 2, 3 or 4 it's not possible to use left, right or mid on their own (I don't think).

Andy.