Forum Discussion

KRV 182's avatar
KRV 182
Copper Contributor
Apr 19, 2018
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...
Excel Desktop
Formulas & Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    Apr 19, 2018

    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

     

KRV 182's avatar
KRV 182
Copper Contributor
Apr 19, 2018

Thank you for this but want to split this data into 4 cells VERTICALLY and not horizontally. Pls see attach for example