Forum Discussion
Solved
Need to break up 1 cell into multiple columns (text has multiple conditions)
Need to break up 1 cell into multiple columns (text has multiple conditions) The source cell is as follows: Last, First, MI Rank USSF MAJCOM 123 SQUADRON/OFFICE Rank conditions are as follows: AB...
See if the attached workbook does what you want. I used some helper columns.
With such a value in A2:
In B2: =TRIM(LEFT(SUBSTITUTE(A2, " ", REPT(" ", 255)), 600))
In C2: =TRIM(MID(SUBSTITUTE(A2, " ", REPT(" ", 255)), 600, 255))
In D2: =TRIM(MID(SUBSTITUTE(A2, " ", REPT(" ", 255)), 1100, 1000))
Thank you!