Excel Exporting 1

[estone4009]

I have an excel file that has one column and 39,980 rows. I need to take that and have it put it into a comma seperated file. Ex. A1,A2,A3,A4 Any ideas?

Thanks!

 

[SkipVought]

Hi,

File/SaveAs...

a .csv (comma separated values) file.

Skip,

_{[red]Be advised:[/red]When Viscounts were guillotined just as they were disclosing where their jewels were hidden, it shows to go that you should...
Never hatchet your Counts before they chicken!}

 

[estone4009]

Because each value is in a new row it doesn't put it in a comma delimited file. It just puts each on its own new line. That woul work if I could replace each new line start with a ,.

 

[SkipVought]

Oh,

You want a SINGLE line output into a file?

That would have to be done with a VBA program.

Post in the VBA Forum forum707.

Skip,

_{[red]Be advised:[/red]When Viscounts were guillotined just as they were disclosing where their jewels were hidden, it shows to go that you should...
Never hatchet your Counts before they chicken!}

 

[macropod]

Alternatively, for a one-off job, output the file as csv then use Word or Notepad to do a find/Replace, changing the para markers to comas.

Cheers

 

[SkipVought]

macropod,

Good suggestion ==>*

Skip,

_{[red]Be advised:[/red]When Viscounts were guillotined just as they were disclosing where their jewels were hidden, it shows to go that you should...
Never hatchet your Counts before they chicken!}