function to concatenate range
 

Is there a text function that will concatenate together the contents of a
range, analogous to SUM()?

CONCATENATE() doesn't seem to work on ranges...

function to concatenate range
 

Unfortunately there is no such function.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"GoBobbyGo" wrote in
message
...
Is there a text function that will concatenate together the
contents of a
range, analogous to SUM()?

CONCATENATE() doesn't seem to work on ranges...

function to concatenate range
 

On Tue, 18 Apr 2006 13:53:02 -0700, GoBobbyGo
wrote:

Is there a text function that will concatenate together the contents of a
range, analogous to SUM()?

CONCATENATE() doesn't seem to work on ranges...

If you download and install Longre's free morefunc.xll add-in from
http://xcell05.free.fr/

you can then use the MCONCAT function which will do what you describe, also
with an optional separator.
--ron