Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

exporting comma seperated file from excel

Status
Not open for further replies.
Pistol34

Pistol34

MIS
Nov 17, 1999
55
US
I need to export a comma seperated file use quotation mark text qualifiers. I can easily export CSV's but no quotes. I must have the quotes for the import. Any idea's would be great

 
Sort by date Sort by votes
I have a similar problem but importing into Excel, the quotation marks are lost when importing to cells?
The only way I include the quotes back is to insert a new column and then use concatenate command to put aq comma before and after.
 
Upvote 0 Downvote
If you don't understand firthr, what he means is:

Values are in columns a, b, and c.

In column d, you put this:

="""a1&"""&"""b1&"""&"""&c1"""

techsupportgirl@home.com
Brainbench MVP for Microsoft Word
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Bijugate
  • Locked
  • Question
Excel update question
Replies
0
Views
295
Bijugate
Bijugate
Pirouette
  • Locked
  • Question
Excel workbook
Replies
1
Views
291
combo
combo
shytott
  • Locked
  • Question
Excel - Toggle Button Code 1
Replies
10
Views
867
shytott
shytott
renigar
  • Question
Excel Power Query refresh error
Replies
3
Views
654
SoftwareRT
SoftwareRT
arvarr
  • Locked
  • Question
Excel Formula Help 1
Replies
7
Views
304
SkipVought
S

Part and Inventory Search

Sponsor

Back
Top