Indeed, it has a 255 character limit, like all other text functions.
Unfortunately, this limit is due to the data type (XLOPER) used by XLL addins.
There is no known workaround.

Sorry, I have mentioned this limit in the help file for other text functions,
but not for MCONCAT.

Laurent

Ron Rosenfeld a écrit :
On Mon, 28 Nov 2005 09:00:59 -0500, lehigh46 wrote:


Hi All,

Does anyone know if MCONCAT has a length limitation?

Thanks for your help?

Tom Snyder


Empirically, Longre's MCONCAT from morefunc.xll seems to have a 255 character
limit.


--ron