Split/Convert From 1 Cell To be Dataset

[muhammad susanto]

hi all..

i have data layout like this into in 1 cell

John Steven 198704171997031001 Jakarta, 20-04-1970

how to split/convert to be dataset, like this:

John Steven

198704171997031001

thanks in advance

sst.

 

[StephenCrump]

Will this work for you?

	A	B	C	D
1	John Steven 198704171997031001 Jakarta, 20-04-1970		John Steven	198704171997031001
Sheet1

Cell Formulas
Range	Formula
C1:D1	C1	=TAKE(TEXTSPLIT(A1,CHAR(10)),,2)
Dynamic array formulas.

 

[SunnyAlv]

try kya gini bro

=TEXTSPLIT(C3,CHAR(10))

 

[muhammad susanto]

hi guys, thank you' worked great.