On 14 Mar 2006 16:47:46 -0800, "Harlan Grove" wrote:

Ron Rosenfeld wrote...
...
To use MCONCAT, you'll need to download and install Longre's free morefunc.xll
add-in from http://xcell05.free.fr/

Note also that MCONCAT chokes (returns #VALUE!) if its result would
exceed 255 characters. If result strings could exceed 255 characters,
VBA is the only alternative.

Good point, and with a range the size the OP mentioned, he would likely exceed
255 characters.
--ron