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
- After you've split the text into columns, you can copy and the "Special Paste > Transform" to pivot the data to individual rows.
My text is stacked in one on top of the other in a single cell like this (see below). All this text is in 1 cell and need to know how to separate this text into 4 cells (see attch) using a formula
ABC 0004
ABC 0020
ABC 0040
ABC 0048
