Windows XP SaveAs xlCSV with Quotes in Data

M

macronovice

Joined
Dec 5, 2008
Messages
3
Reaction score
0
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""".
 
Well it works for me - see attached...
You could then record a macro to automate it.
 

Attachments

  • z.webp
    z.webp
    27.5 KB · Views: 228
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?
 
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.
 
Back
Top