I have this
="MML "& SUBSTITUTE(MID(B1,FIND("X",B1)-3,LEN(B1)),"= ","= "&MID(B1,1,FIND(" ",B1,1)-1)&" ")
That converts
<colgroup><col width="363"></colgroup><tbody>
</tbody>
to
MML 25 X 35 = ARIEL SNOW WHITE WM290A
I now want the above to be ( shift last word to second word after = )
MML 25 X 35 = ARIEL WM290A SNOW WHITE
<tbody>
</tbody>
="MML "& SUBSTITUTE(MID(B1,FIND("X",B1)-3,LEN(B1)),"= ","= "&MID(B1,1,FIND(" ",B1,1)-1)&" ")
That converts
ARIEL WALL 25 X 35 = SNOW WHITE WM290A |
<colgroup><col width="363"></colgroup><tbody>
</tbody>
to
MML 25 X 35 = ARIEL SNOW WHITE WM290A
I now want the above to be ( shift last word to second word after = )
MML 25 X 35 = ARIEL WM290A SNOW WHITE
<colgroup><col width="64"></colgroup><tbody> </tbody> |
<tbody>
</tbody>