Forum Discussion
Solved
4 rows of data in 1 cell . Split into 4 cells
Wanted to know how to split data in a cell into multiple cells. I have 4 rows of data in 1 cell and want to split the data into 4 cells. I know what text to column does but this doesn't apply. Also I...
That is approximately the same
=TRIM(MID(SUBSTITUTE($B$4,CHAR(10),REPT(" ",LEN($B$4))),(ROW()-ROW($A$8))*LEN($B$4)+1,LEN($B$4)))in B8 on screenshot and drag down
and attached
Thank you for this but want to split this data into 4 cells VERTICALLY and not horizontally. Pls see attach for example
That is approximately the same
=TRIM(MID(SUBSTITUTE($B$4,CHAR(10),REPT(" ",LEN($B$4))),(ROW()-ROW($A$8))*LEN($B$4)+1,LEN($B$4)))
in B8 on screenshot and drag down
and attached
THIS IS 100% WHAT I WAS LOOKING FOR!!!!!!
Thank you