Splitting a space delimited cell

  • Thread starter Thread starter Mossimus
  • Start date Start date
M

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?
 
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
 
Back
Top