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

H

hobiedog

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

Markus L

hobiedog said:
I need to place text seperated by a space in one column into two seperate
columns.
Click to expand...

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!
 
Top