Spillting a cel
 

I was able to import my text files into a spreadsheet, but here is what
I need to do next and I hope there is an easier way to do this through
the program. Her is what I have, I have a product spreadsheet that
includes item number followed by the description. the item number is
always first and needs to be broken out into its own column with the
description in the next.

What I am wanting to know, how do I have excel grab the first part of
the column up until after the first space and leave that in one column
and put the rest of the information in a new column. That would allow
me to import into Access and key off the item number field.

Any and all help would be appreciated.

Michael

Spillting a cel
 

Hi

Ensure there is a blank column to the right of your data.
Mark the column, DataText to ColumnsDelimitedClick Space as
delimiterOKOK

--
Regards

Roger Govier


wrote in message
ups.com...
I was able to import my text files into a spreadsheet, but here is what
I need to do next and I hope there is an easier way to do this through
the program. Her is what I have, I have a product spreadsheet that
includes item number followed by the description. the item number is
always first and needs to be broken out into its own column with the
description in the next.

What I am wanting to know, how do I have excel grab the first part of
the column up until after the first space and leave that in one column
and put the rest of the information in a new column. That would allow
me to import into Access and key off the item number field.

Any and all help would be appreciated.

Michael