View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.setup
Helena James Helena James is offline
external usenet poster
 
Posts: 1
Default XLS in CSV with " and ;

You will find that Excel will put the quotation marks around a field of text
where it needs to, ie where the text contains a comma, and doesn't do so in
other cases, as it is not necessary. For eg if you opened the csv file in
Note pad you would see something like:

xx, yy yy, "xx,xx"

The first two strings do not need the quotation marks, but the third does as
it contains the delimiter used in the csv file, ie a comma.

--
Helena James


"Frank Matheis" wrote:

Hi there,

we have a XLS (Excel 2007) file and want to save it as *.csv in the format
like "datarecord";"datarecord2";"..... but Excel only uses ; and no " signs
between the data. Does anybody know how to get this solved?
Thank you in advance

Frank Matheis