function to concatenate range

G

GoBobbyGo

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...
 
R

Ron Rosenfeld

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...
Click to expand...

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
 
Top