Thank you sooooo much. I wasn't really sure how to put the functions
together to make it all work.
--
Thomas


"Carim" wrote:

Hi Thomas,

=IF(LEN(A1)=2,1,VALUE(MID(A1,LEN(A1)-4,2)))

should do the job ...

HTH
Cheers
Carim