#1   Report Post  
Old February 21st 08, 02:48 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2008
Posts: 1
Default XLS in CSV with " and ;

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

  #2   Report Post  
Old March 7th 08, 04:10 AM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2008
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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
change "true" and "false" to "availble" and "out of stock" inthestands Excel Worksheet Functions 2 July 19th 07 07:05 PM
HELP on "left","right","find","len","substitute" functions serene83 Excel Discussion (Misc queries) 5 June 27th 06 02:23 AM
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next BCB New Users to Excel 7 May 13th 06 10:02 PM
Complex if test program possible? If "value" "value", paste "value" in another cell? jseabold Excel Discussion (Misc queries) 1 January 30th 06 10:01 PM
Insert "-" in text "1234567890" to have a output like this"123-456-7890" Alwyn Excel Discussion (Misc queries) 3 October 25th 05 11:36 PM


All times are GMT +1. The time now is 12:06 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017