Help putting left, right, find and len together
=MID(A2,FIND(" ",A2)+1,FIND("X",A2)-FIND(" ",A2)-1)
=MID(A2,FIND("X",A2)+1,FIND("X",A2,FIND("X",A2)+1)-FIND("X",A2)-1)
=MID(A2,FIND("X",A2,FIND("X",A2)+1)+1,FIND("
",A2,FIND("X",A2,FIND("X",A2)+1)-FIND("X",A2)-1))
=MID(A2,FIND(" ",A2,FIND(" ",A2)+1)+1,FIND(" ",A2,FIND(" ",A2,FIND("
",A2)+1)+1-FIND(" ",A2,FIND(" ",A2)+1))-1)
=RIGHT(A2,LEN(A2)-FIND(" ",A2,FIND(" ",A2,FIND(" ",A2)+1)+1))
Yowza!
"Glenda" wrote:
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.
|