Converting Excel file to CSV Format

  • Thread starter Thread starter Anne
  • Start date Start date
A

Anne

When I tried converting the excel file to CSV format, if
my text in one of the columns contains inverted commas
Eg: 10" Pipes; after conversion, if i open the csv file
by using notepad, it will appear as "10" Pipes". How to
avoid having the system auto-adding the open converted
commas to the text.

TQ
 
You cant use comma's when converting to a csv file
because it splits the cells by the comma's, i.e Comma
Seperate Value (csv).

If you can use a different value from comma that will
solve this immediately
 
I believe by inverted commas you mean quotes. Excel adds quotes in creating
CSV files in an effort to reduce ambiguity since quotes are also used to
delimit text by some programs. In any case you can't modify how Excel saves
files. The easiest course is to do a Find on quotes and replace them with
"inch".

If that's not an option you'll have to use a macro to create the CSV file.
Chip Pearson has a page on that:

http://www.cpearson.com/excel/imptext.htm
 
Back
Top