mconcat

  • Thread starter Thread starter excelstruggler
  • Start date Start date
E

excelstruggler

hi guys,

i'm a newb with excel. i'm using mconcat which is cool along wit
'vlookups' function, but it doesn't seem to like long text strings whe
concatenating even if they are all in one cell it wont concatenate i
too long.


please help!

btw: i know nothing about VBA so if you could help without using tha
then it owuld be good
 
Hi
there's a restriction in the maximum of characters. To
circumevent this you'll have to change the VBA routines.
So without VBA no chance
 
excelstruggler wrote...
i'm a newb with excel. i'm using mconcat which is cool along with
'vlookups' function, but it doesn't seem to like long text strings
when concatenating even if they are all in one cell it wont
concatenate if too long. ...
btw: i know nothing about VBA so if you could help without
using that then it owuld be good.
Click to expand...

MCONCAT and VLOOKUPS aren't built-in functions. MCONCAT is the name o
an add-in function provided by Laurent Longre's MOREFUNC.XLL add-in
and VLOOKUPS is the name of an add-in function provided by Alan Beban'
array function library, which is implemented in VBA.

It's the former that causing you problems, which you don't mention bu
which I'd guess is the error return value #VALUE!. There's no way t
fix MCONCAT so that it could return strings longer than 255 characters
That's a limit built into the interface between Excel and XLL add-ins.

You could use work-alike user-defined functions in place of MCONCAT
but they *REQUIRE* VBA. So, if you want to be able to do this, you nee
to use VBA. If you won't/can't use VBA, you just can't do what you'r
trying to do in Excel
 
Back
Top