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
|