Help putting left, right, find and len together
Now that is taking all the fun out! That's a lot easier....
"MartinW" wrote:
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.
|