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

"hobiedog" <hobiedog@discussions.microsoft.com> wrote in message
news:51E83932-9EEE-4A31-A692-0F1FB6E5D090@microsoft.com...
> 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" <hobiedog@discussions.microsoft.com> wrote in message
news:51E83932-9EEE-4A31-A692-0F1FB6E5D090@microsoft.com...
>I need to place text seperated by a space in one column into two seperate
> columns.

"hobiedog" <hobiedog@discussions.microsoft.com> wrote in message
news:51E83932-9EEE-4A31-A692-0F1FB6E5D090@microsoft.com...
> 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" <hobiedog@discussions.microsoft.com> wrote in message
news:51E83932-9EEE-4A31-A692-0F1FB6E5D090@microsoft.com...
>I need to place text seperated by a space in one column into two seperate
> columns.

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

"hobiedog" <hobiedog@discussions.microsoft.com> wrote in message
news:51E83932-9EEE-4A31-A692-0F1FB6E5D090@microsoft.com...
> 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" <hobiedog@discussions.microsoft.com> wrote in message
news:51E83932-9EEE-4A31-A692-0F1FB6E5D090@microsoft.com...
>I need to place text seperated by a space in one column into two seperate
> columns.