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.