View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default comma delimited & surrounded by quotes

One way:

http://www.mcgimpsey.com/excel/textf...#csvwithquotes

In article ,
Rk wrote:

hi , does anyone know how to out put data from a excel spread sheet so it is
in the following format

in spreadsheet 1 2 3 4 5

output

"1","2","3","4","5"

tried .csv but that is just 1,2,3,4,5