On Wed, 23 Jul 2008 11:46:21 -0700, Gary Brown
wrote:

Ron,
What is MConCat? I can't find it in the list of functions for 2003. Is
it new to 2007?
--

It is a function from Laurent Longre's morefunc.xll add-in (presumably):

MCONCAT
Concatenates all data in a range or an array.

SYNTAX :
=MCONCAT(Array,Separators)

- Array : range or array. All data types are supported.

- Separators (string, optional) : one or more characters separating the items
in the concatenated string.

MCONCAT concatenates the items from left to right and from top to bottom. For
instance, =MCONCAT(A1:C3) returns the same string as
=A1&B1&C1&A2&B2&C2&A3&B3&C3.

EXAMPLES :
The range "PL" (5 rows * 4 columns) containing the integers 1 to 20 :

=MCONCAT(PL) returns "1234567891011121314151617181920"

=MCONCAT(PL," ") returns "1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20"
--ron