converting rows to comma delimited list

P

peterswan

Hello,

Is there a way to take a ton of rows of an id in the first column, an
output them into a comma delimited list so I can load them into a SQ
query and search on them?

Once I saw someone do this with the concatenate function but I can'
remember how it was done. If I could just add a comma on the end o
every instance of the id, I'd be solved.

Thanks,

:) :)
Pete
 
P

peterswan

any help?

I've got 3000+ rows and just one column, an id field.

All I need to do is throw a comma in after every id.

That way I can copy the whole column and paste it into SQL Quer
Analyzer.

Thanks for any help,

:) :)

Pete
 
G

Gord Dibben

Peter

Assuming column of data is A.

In B1 enter =A1 & ","

Double-click on the B1 fill handle to copy down 3000+ cells.

Copy Column B and Paste Special(in place)>Values>OK>Esc.

Delete Column A.

Gord Dibben Excel MVP
 
Top