Hi all,

Got one that I've been trying to work out.

Going to be simple but I still cant seen to work it out.


I have a string of data:

1,100,315.00ZuAl2,336.00PW100.00

And what I need to extract is the 100 after the PW but the string can also be

1,100,315.00ZuAl2,336.00PW80.00

The 80 or 100 can be any number, but will alway be a 2 or a 3 digit number

I've tried the =Right(A1, Len(a1)-24)

Bu tthis brings back the .00 after the numbers.

Ive tried combining left and mid but with no luck.

Any help?

Thanks