View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default Quote Marks Question

Hi Bob,

Am Fri, 15 Nov 2013 09:27:57 -0500 schrieb Bob:

Anyway, if I now look at the spreadsheet with Notepad, all the cells I
put the single set of quote marks around now have three sets.
e.g., "Bob" now shows in Notepad as """Bob"""


that is the behaviour of CSV.
Put a single set quotes marks (") in a cell and save the file as CSV. If
you open it with Editor you see """"


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2