Extract Data From Single Cell [merged] to Multiple Column

[muhammad susanto]

hi all.

how to extract data from single cell (merged cell) like this:

Book1
	A	B	C	D	E
1	data	extract
2	Mr XXX 198505162008121003 New York, 16-05-1985	Mr XXX	198505162008121003	New York	16/05/1985
3
4
5
6
7	Mrs. YYYY 197404231996021001 Hongkong, 23-04-1974	Mrs. YYYY	197404231996021001	Hongkong	23/04/1974
8
9
10
11
12	Mr ZZZZZZZZZ 198301282009012003 France, 28-01-1983	etc…...
13
14
Sheet1

thanks in advance,

 

[arthurbr]

=IF(A2<>"",TRIM(TEXTSPLIT(SUBSTITUTE(A2,CHAR(10),"%"),{"%",","}),"")

 

[muhammad susanto]

thank you very much guys. it was help me.

 

[Peter_SSs]

You're welcome. Glad we could help. Thanks for the follow-up.