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 Puzzling quotes around text

Hi Terry,

Am Tue, 26 Mar 2013 16:43:15 +0000 schrieb Terry Pinnell:

I opened a CSV comma-delimited file in Excel 2000. Then I edited one of
its columns, typically deleting parts at the start and end. These included
some 'non-printing' characters (small rectangles, etc).

When viewed in a text editor, some of these text strings are "surrounded
by quotes", yet others are not.


if into a cell is a text string with a sign normally used to delimit the
cells, this text string must be entered with quotes


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