How to transpose and concatenate long list in one column?

Posted to microsoft.public.excel.worksheet.functions

CSchwass

external usenet poster

Posts: 10

How to transpose and concatenate long list in one column?

I have a list like this in column A:

2345
1023
1492
2985
2902
etc

....but much longer. I want this result in one cell:

2345,1023,1492,2985,2902,etc

I will continually add to the list in Column A and I don't want to update
the formula every time for the CSV cell.

How can I do this?

Thanks,
Chris

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Need a formula to 'find' word in cells of column from a long list	Deden	Excel Worksheet Functions	10	November 26th 08 02:30 AM
Transpose after CONCATENATE	armymatt	Excel Worksheet Functions	1	February 13th 08 04:55 PM
Transpose several columns to one long column	sofast1651	Excel Discussion (Misc queries)	1	February 4th 08 11:08 PM
How to transpose a long list of text across cells	[email protected]	Excel Discussion (Misc queries)	2	July 28th 06 06:42 PM
how do you keep fields in a column to print out for long list	Mike	Setting up and Configuration of Excel	1	August 31st 05 09:14 PM

All times are GMT +1. The time now is 03:07 PM.

Menu

About Us