Split content of the cell

[pukiamak]

Hello guys,

I have excel rows with the following format

Row 2:" 120 250 700"
Row 3:" 120 250 700"

I want to split the content of the cell into

Column 1: 120
120

Column 1: 250
250 and so on

the delimiter is the space.

Thank you guys,
Tony

 

[AnotherHiggins]

Have a look at Edit > Text To columns > Delimited.

If you need code, just turn on the macro recorder and go through the steps (Tools > Macro > Record New Macro).

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.

 

[tekuser999]

Very useful function but is that a new feature in excel 2003? It is not available in my excel XP.

 

[PHV]

menu Data -> Convert ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886