MCONCAT

  • Thread starter Thread starter lehigh46
  • Start date Start date
L

lehigh46

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.
 
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
 
I've never used Laurent Longre's function, but there are limitations in builtin
functions when you're retrieving from a closed workbook.
 
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 :
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MCONCAT only Visible Cells 3
MCONCAT 3
Replacing MCONCAT with CONCAT_RANGE (in a complicated formula) 0
Replacing MCONCAT with CONCAT_RANGE (UDF) 8
Concatenate Text... with spaces 2
mconcat 2
Help with formula 2
Modifying a Formula To display only Unique Values 1

Back
Top