MCONCAT

  • Thread starter Thread starter Carl
  • Start date Start date
C

Carl

I downloaded the add-in. When I run the function on a few
cells it works.

When I run it on 200 cells I get "#VALUE!"

Can the formula be used on 200 cells ?

Thank you in advance.
 
The formula has a limit of 255 characters... you could split it in two:

=MCONCAT(A1:A100)&MCONCAT(A101:A200)
 
I downloaded the add-in. When I run the function on a few
cells it works.

When I run it on 200 cells I get "#VALUE!"

Can the formula be used on 200 cells ?
Click to expand...

You may need to enter MCONCAT as an array formula, so hold down [Ctrl] and
[Shift] keys before pressing [Enter].
 
Back
Top