21 12 11.xlsm | |||||||||
---|---|---|---|---|---|---|---|---|---|
H | I | J | K | L | M | N | |||
1 | |||||||||
2 | A;B;C | A | B | C | |||||
3 | School;Uni;Pre;College | School | Uni | Pre | College | ||||
4 | The cat sat on the mat;The dog ran out the door;The mouse stayed still | The cat sat on the mat | The dog ran out the door | The mouse stayed still | |||||
Split Text |
Cell Formulas | ||
---|---|---|
Range | Formula | |
J2:L2,J4:L4,J3:M3 | J2 | =TRANSPOSE(FILTERXML("<p><c>"&SUBSTITUTE($H2,";","</c><c>")&"</c></p>","//c")) |
Dynamic array formulas. |