Extract text/string to multiple rows after space..

[muhammad susanto]

hello all,

i have following problem about extract text/string name from one row/one cell to multiple rows after each space

see this below :

[TABLE="width: 500"]
<tbody>[TR]
[TD]name (raw data)[/TD]
[TD]expected result[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ida kusharjanti[/TD]
[TD]ida[/TD]
[TD]kusharjanti[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ADINDA LATHIFA MAHESWARI[/TD]
[TD]ADINDA[/TD]
[TD]LATHIFA[/TD]
[TD]MAHESWARI[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]BRAMAZANI MUHAMMAD MULYA ARROZAQ[/TD]
[TD]BRAMAZANI[/TD]
[TD]MUHAMMAD[/TD]
[TD] MULYA[/TD]
[TD]ARROZAQ[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]etc...[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

for anybody help me, thanks in advance...

m.susanto

 

[VoG]

Try Data > Text to Columns, Delimited with Space as the delimiter.

 

[muhammad susanto]

thanks VoG, that was helpfull