How to seperate data in a cell which is split by a comma
 

Hi,

I have an excel sheet which holds exported (back up) data from an access
database. When the data is exported into excel all my columns in my access
sheet are merged into a singel excel column with each access cell in
quotations seperated by a comma all in the same excel cell. Any ideas how to
get excel to split this data across columns and drop the " "???

Regards,
Eamonn

How to seperate data in a cell which is split by a comma
 

Hi

Have a look at Data/Text to columns. Make sure you backup your data before
you start!

Andy.

"Eamonn" wrote in message
...
Hi,

I have an excel sheet which holds exported (back up) data from an access
database. When the data is exported into excel all my columns in my access
sheet are merged into a singel excel column with each access cell in
quotations seperated by a comma all in the same excel cell. Any ideas how
to
get excel to split this data across columns and drop the " "???

Regards,
Eamonn