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
Bookmarks