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

One way:

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

In article <BFAF03D6-5775-4E0D-A353-(E-Mail Removed)>,
Rk <(E-Mail Removed)> 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

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

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" <(E-Mail Removed)> wrote in message
news:BFAF03D6-5775-4E0D-A353-(E-Mail Removed)...
> 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