PC Review


Reply
Thread Tools Rate Thread

How do I save to csv and get text delimeters?

 
 
Jack
Guest
Posts: n/a
 
      9th Nov 2006
I'm using Excel 2003 and when I save a file as a CSV it does not ad the
text delimeter. I get


Smith,John A

Instead of "Smith","John A"

How do I get the text delimeters? I've tried setting the format to text
instead of general

 
Reply With Quote
 
 
 
 
Earl Kiosterud
Guest
Posts: n/a
 
      9th Nov 2006
Jack,

Normally, the text qualifiers (quote marks) aren't needed unless the field
contains comma or quotes within the data. But if you need them, get the
Text Write Program from
http://www.smokeylake.com/excel/text_write_program.htm. There's an option
to put any text qualifier you want around all fields.
--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"Jack" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> I'm using Excel 2003 and when I save a file as a CSV it does not ad the
> text delimeter. I get
>
>
> Smith,John A
>
> Instead of "Smith","John A"
>
> How do I get the text delimeters? I've tried setting the format to text
> instead of general
>



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro to copy text between delimeters Vic Microsoft Excel Programming 4 11th Apr 2007 12:40 AM
Macro to copy text between two different delimeters vdossey@hotmail.com Microsoft Excel New Users 1 6th Apr 2007 04:54 PM
Find a string between two delimeters and replace with text Jeff Microsoft Excel Programming 2 2nd May 2006 08:15 PM
Import text file into excel with preset file layout, delimeters VBA meldrape Microsoft Excel Programming 7 15th Jun 2004 09:31 PM
Reading files with delimeters R.A. Microsoft C# .NET 3 31st Mar 2004 11:55 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:33 PM.