De-concatenate

[randy__6]

How can I break up info in a single cell into multiple cells.

Ex:

I have one cell that contains "xts jbd land inf"
and I want 4 cells: "xts" "jbd" "land" "inf"

So pretty much divide the cells at the spaces.

 

[VoG]

Data > Text to Columns.

 

[Richard Schollar]

...and use space as a delimiter.

 

[Gerald Higgins]

Is it always breaking into 4 cells, with a single space between each chunk, and always exactly 3 spaces altogether ?

Take a look at Data, Text to Columns, Delimited, specifying space as the delimiter.

If that does not do it, you can write a formula to do it - post back if Text to Columns doesn't work.