View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Eamonn
 
Posts: n/a
Default 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