A couple questions I need answered first, you show values from A2,B2 etc, do
these numbers have meaning? Are they always the same length. Is there a
consistent amount of numbers before the first letter? and finally you say
there could be up to 3 numbers that you need, how do you know how many you'll
need?
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Jules" wrote:

Hi...I have a problem I've been working on for a while now...to no avail.

a2=200865346120565131TED STOCK THIGH HIGH XL 3922

I'm managed to get to

a2=2008653461
b2=20565
c2=13
d2=131ted stock thigh high xl 3922
e2=ted stock thigh high xl 3922

Problem is D2 - I need the one after the three...

It is not consistent in the database...

But what is consistent is I need the one right before the text begins (some
times it may be up to three numbers) all located before the text.

Any help would be great!

Thanks
jules
01.20.09

--
Jules