Windows XP SaveAs xlCSV with Quotes in Data

[macronovice]

In my Excel Spreadsheet some data cells have quotes, example "PP".
When I save it as a CSV and then open in notepad it looks like """PP""".

I need help. I only need "PP" not """PP""".

 

[TriplexDread]

Welcome to the Forum

 

[shazbat99]

Try find "" replace " from the edit menu.

 

[macronovice]

Excel could not find any ""
That does work in Notepad - but I need it automated

 

[shazbat99]

Well it works for me - see attached...
You could then record a macro to automate it.

 

[macronovice]

It did work for you, but you misunderstood my situation.

In my situation Excel shows it as "PP". It does not show as """PP""" as in your example.

It does not show as """PP""" until I open it in Notepad after saving as ".csv" from Excel. For some reason when I save it as ".csv" it adds double quotes on either end that cannot be found in Excel.

Can you help with that?

 

[shazbat99]

I don't understand why you would want to open it using Notepad, as Excel is much more useful. But you could do a find replace in Notepad in anycase.

Sorry can't be of any more help.