place text seperated by a space in a column into seperate columns

[Guest]

I need to place text seperated by a space in one column into two seperate
columns.

 

[Markus L]

I need to place text seperated by a space in one column into two seperate
columns.

This is my "quick and dirty" solution (at 32C/90F in my office today it's
simply too hot to develop any formula :
- isolate the column containing the 2 text elements (copy it into a new
workbook)
- save as text file (tab delimited)
- open text file, choose delimited and space as delimiter
- copy back the resulting 2 columns into your original workbook

I'm sure one of the gurus will come up with an elegant formula.
The choice is yours!

 

[Guest]

Hi
I reckon Data|Text To Columns should do the trick for you.