Splitting a space delimited cell

[Mossimus]

I have a column of cells each containing two alphanumeric strings separated
by a space.

i.e. abc12 def3 Now these strings are of varying sizes I would like to
split them up and put into two seperate cells
so abc123 would be in one cell and def3 in another.

How would I go about this in Excel?

 

[Dan E]

Mossimus,

Select your range of data (ensure you have a blank column on the left side
of your data) choose "Data" -> "Text to Columns"
Select "Delimited" and go Next
Make sure you have the "Space" delimiter checked and click finish

Dan E

 

[Dan E]

Oops,
Blank column on right . . .

Mossimus,

Select your range of data (ensure you have a blank column on the left side
of your data) choose "Data" -> "Text to Columns"
Select "Delimited" and go Next
Make sure you have the "Space" delimiter checked and click finish

Dan E


http://members.ud.com/services/teams/team.htm?id=CF728396-DDAA-4B0A-84E6-221