Posted to microsoft.public.excel.programming

external usenet poster

Posts: 95

Concatenate anyone?

Does anyone know how to:
Select a group of cells, say in a table column,
concatenate the contents (perhaps separated by commas)
and copy over to a cell selected in Sheet2?

I tried to record a macro to do this then install a RefEdit into the macro,
but I am a total bottom-eater at excel VBA.

Regards
Dylan Dawson
Scotland

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
Concatenate	Sheriff	Excel Worksheet Functions	1	May 25th 08 11:07 AM
Help with CONCATENATE!	Nic	Excel Discussion (Misc queries)	6	November 24th 06 09:38 PM
De-concatenate?	KevinMB	Excel Discussion (Misc queries)	2	August 30th 05 05:17 PM
I know how to concatenate ,can one de-concatenate to split date?	QUICK BOOKS PROBLEM-	New Users to Excel	1	July 26th 05 05:07 PM
CONCATENATE	AYPCN	Excel Programming	2	March 9th 05 09:05 PM

All times are GMT +1. The time now is 01:22 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us