Negate an array?

[zanguard80]

As part of a formula I have the following evaluation:

=CONCATENATE({"Example 1","Example 2"})

I would like the CONCATENATE function to return "Example 1Example 2", but it doesn't because the preceding elements are in an array. Is there any way to negate the array so it appears as CONCATENATE("Example 1","Example 2") instead?

Thanks.

The document will be used with Excel 2010 and cannot contain VBA scripts.

[Olly]

There's no simple formula available to join an array. It's trivial with a small UDF:

Please Login or Register  to view this content.

[Olly]

You could do it with a helper range to split the array into distinct values, then concatenate those.

Or you could come up with something truly horrible and inefficient like this:

Please Login or Register  to view this content.

extended to cope with your expected array upper bound... but that's NASTY!

[zanguard80]

Thanks. Bumping to see if there are any other solutions.

[FDibbins]

Why is that an array in the 1st place?