Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|