Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
comma delimited & surrounded by quotes
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 -- thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
comma delimited & surrounded by quotes
Unfortunately, to get quotes you need to actually embed them in the file,
save it as a text file, and then rename it to a csv. If your example numbers are in row 1, in columns A-E, then in F1 use the formula: =""""&A1&""","&""""&B1&""","&""""&C1&""","&""""&D1 &""","&""""&E1&"""" copy it down as far as you need, then select all the formulas, press Ctrl-C to copy them, then Edit-Paste Special-Values to replace the formulas with the results. Then delete columns A-E and save the file as text "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 -- thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
comma delimited & surrounded by quotes
Rk,
The Text Write Program at http://www.smokeylake.com/excel/text_write_program.htm will do that for you interactively (no code required, though you could copy the code into your own macro if you wanted to. Set"Bracket all fields" to yes. -- Regards from Virginia Beach, Earl Kiosterud www.smokeylake.com Note: Top-posting has been the norm here. Some folks prefer bottom-posting. But if you bottom-post to a reply that's already top-posted, the thread gets messy. When in Rome... ----------------------------------------------------------------------- "Rk" wrote in message ... 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 -- thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Comma Delimited Numbers | Excel Discussion (Misc queries) | |||
Output space-delimited file with quotes around text? | Excel Discussion (Misc queries) | |||
Creating CSV Comma Delimited File | Excel Discussion (Misc queries) | |||
Need quotes around exported tab delimited text | Excel Discussion (Misc queries) | |||
Comma delimited question | Excel Discussion (Misc queries) |