Hi All,

Does anyone know if MCONCAT has a length limitation?

Thanks for your help?

Tom Snyder

MCONCAT isn't an XL function.

If you're talking about Laurent Longre's morefunc.xll utility MCONCAT, I
believe it's 256 characters.

If you're talking about someone else's MCONCAT, it's hard to know.

In article ,
lehigh46 wrote:

Hi All,

Does anyone know if MCONCAT has a length limitation?

Thanks for your help?

Tom Snyder

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

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

I've never used Laurent Longre's function, but there are limitations in builtin
functions when you're retrieving from a closed workbook.



lehigh46 wrote:

Hi All,

Does anyone know if MCONCAT has a length limitation?

Thanks for your help?

Tom Snyder

--

Dave Peterson