| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Split data from one cell to two separate cells | Excel Worksheet Functions | |||
| Input Cell in One variable data table | Excel Worksheet Functions | |||
| Sort pages? | Excel Discussion (Misc queries) | |||
| Splitting Data in a Cell | Excel Worksheet Functions | |||
| Seperate the data from the Cell | Excel Worksheet Functions | |||
Linear Mode
