Hi Glenda,

I put your example in A1 and went to DataText to Columns
Checked Delimited and Next
Checked Space and checked Other and put an X in the input box
then clicked Finish.

I ended up with
AB | 5 | 75 | 200 | YD | G5487L
in A1 to F1.

Is that what you are looking for?

HTH
Martin



"Glenda" wrote in message
...
I need to pull the following string apart in several different ways and I
can't get the combination of the functions right for it to work.

example of string:
AB 5X75X200 YD G5487L

First - I want to look at the string and pull out the dimensions 5, 75,
and
200 and put them in separate cells. character counts will not always be
the
same

Second - YD may not always be YD it could also be LY

Third - I need to start at the right find the space and pull everything
out
to the right of the space.