View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Hannes Prokop Hannes Prokop is offline
external usenet poster
 
Posts: 1
Default CSV export, deliminating character

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