Forum Discussion
Word between words
I have the attached file and I was able to break down the entire line just missing one, but since the results do not have the extra empty space I don't know how to tell excel to bring from the raw data A2 everything between B2&C2&D2 and F2&G2&H2&I2
Fernando,
B2 =TRIM(LEFT(A2,9)) C2 =TRIM(MID(A2,10,11)) D2 =TRIM(MID(A2,22,4)) F2 =LEFT(B2,5) G2 =TRIM(MID(A2,101,3)) H2 =MID(A2,105,7) I2 =TRIM(MID(A2,118,8))
But I don't know why D3 and D4 should be empty.
The original data had a lot of nonuniform empty cells, I could find formula for all the cell but one so that is the reason why I want to do a formula to get everything after the last cell and before the others
Detlef_Lewin wrote:
Fernando,
B2 =TRIM(LEFT(A2,9)) C2 =TRIM(MID(A2,10,11)) D2 =TRIM(MID(A2,22,4)) F2 =LEFT(B2,5) G2 =TRIM(MID(A2,101,3)) H2 =MID(A2,105,7) I2 =TRIM(MID(A2,118,8))
But I don't know why D3 and D4 should be empty.
I assumed you showed the desired result since there were no formulas in the workbook.
It is not clear to me what you really want. Obviously not formulas.
