D
deininger
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
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