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