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

     

Haytham Amairah's avatar
Haytham Amairah
Silver Contributor
Apr 19, 2018

Hi,

 

We've discussed almost the same issue here in this conversation.

Please refer to it.

 

 

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

Thank you for your response but I have no admin rights to get Get & Transform (Power Query) and the support guys here will not add it for me. If there is no other way pls let me know

Resources