Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am trying to export an excel file to csv. But unlike the name
"comma-separated..." suggests excel uses semicolons to seperate my cells. I would need the cells separated by commas rather. As some of my cells contain semicolons as data, the workaround of replacing all the ; with , in wordpad does not work. I already tried to change the list-seperate character in windows-regional options but that didn't work either. Thanks in advance... Hannes |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2007 - Formatting text in cell (character by character) | Excel Discussion (Misc queries) | |||
XML special character export | Excel Discussion (Misc queries) | |||
Deliminating Text | Excel Discussion (Misc queries) | |||
export re-order input fields to export file [csv] | Excel Worksheet Functions | |||
Excel-Match 1st text character in a string to a known character? | Excel Worksheet Functions |