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

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

"hobiedog" wrote in message
...
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!

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

--
Andy.


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