MCONCAT

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

 

[Juan Pablo González]

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

=MCONCAT(A1:A100)&MCONCAT(A101:A200)

 

[Harlan Grove]

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 ?

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