software

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 quot; quot;???

Regards,
Eamonn

Hi

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

Andy.

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