Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
problem office assistant | Excel Discussion (Misc queries) | |||
Excel Display Problem | Excel Discussion (Misc queries) | |||
autofilter problem | Excel Worksheet Functions | |||
Freeze Pane problem in shared workbooks | Excel Discussion (Misc queries) | |||
Row Autofit problem Excel 2003 | Excel Discussion (Misc queries) |