problem with csv
When I export from a database I get the top line all in csv which appears to
be in row A (which is the names of all the columns and the rest of the sheet is correct with all the data in relevant columns. How do I split that top row (which is Comma Separated) into coulumns automatically. I'm sure it is a simply process. thanks plato |
There is an easy way in Excel to split apart a cell without having to re-type
its contents. Click on the cell. Pull-down Data Text to Columns... then check delimited and next check comma. The single cell should then split. Good Luck -- Gary's Student "plato" wrote: When I export from a database I get the top line all in csv which appears to be in row A (which is the names of all the columns and the rest of the sheet is correct with all the data in relevant columns. How do I split that top row (which is Comma Separated) into coulumns automatically. I'm sure it is a simply process. thanks plato |
All times are GMT +1. The time now is 09:20 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com