Carim,

What if the value is BX/5 EA, It worked for BX/50 EA but not the other, what
do I need to change in the string to make it 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