MCONCAT

L

lehigh46

Hi All,

Does anyone know if MCONCAT has a length limitation?

Thanks for your help?

Tom Snyder
 
J

JE McGimpsey

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.
 
R

Ron Rosenfeld

Hi All,

Does anyone know if MCONCAT has a length limitation?

Thanks for your help?

Tom Snyder
Click to expand...

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


--ron
 
D

Dave Peterson

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

Laurent Longre

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 :
 
Top