LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Add double quotes to each field


HI all,

Not sure if this is the correct forum for this question, feel free t
move it if not.

My issue is I have made an excel sheet that contains 500 rows and 1
columns.
I need to export this as a CSV but when exproting, each field MUST b
delimited by double quotes ex: "data"

When taving either as a CSV or tab delimited text, it does not put th
quotes in.
How can I do this?

The data must be formated as such:
"product_sku2","product_s_desc","product_desc","TN _pic2.jpg","pic2.jpg","","","","","","","7","","N" ,"","Produc
Name2","87.78","category/level1/level2|category2/level1/level2","1"

Thank you in advance for any help provided

--
npereir
-----------------------------------------------------------------------
npereira's Profile: http://www.excelforum.com/member.php...fo&userid=1079
View this thread: http://www.excelforum.com/showthread.php?threadid=47537

 
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
Double Quotes [email protected] New Users to Excel 2 July 20th 08 12:43 PM
Double Quotes PeterM Excel Discussion (Misc queries) 5 June 17th 08 05:12 PM
export .CSV with field containing double quotes? William DeLeo Excel Discussion (Misc queries) 5 April 5th 06 06:08 PM
Double Quotes Ed Excel Programming 1 January 13th 04 01:13 AM
Double Quotes Ed Excel Programming 1 January 12th 04 09:18 PM


All times are GMT +1. The time now is 04:09 PM.

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

About Us

"It's about Microsoft Excel"