problem with csv

[plato]

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

 

[Guest]

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