On Tue, 31 Oct 2006 16:49:59 +1300, "Alan" wrote:


Hi All,

I need to work out how to concatenate an array of four strings skin to
the following (which does not work):

=CONCATENATE({"AAA";"BBB";"CCC";"DDD"})

="AAABBBCCCDDD"


Looks deceptively simple, but I am stumped (or stupid!)

Any ideas?

Thanks,

Alan.

Well, you could download and install Longre's free morefunc.xll add-in from
http://xcell05.free.fr/ This add-in is easily distributed with workbooks if
that is an issue.

and then use the formula:

=MCONCAT({"AAA";"BBB";"CCC";"DDD"})

There may be more efficient ways of doing this using native functions, but it's
late, so I can only offer the following:

=INDEX({"AAA";"BBB";"CCC";"DDD"},1)&
INDEX({"AAA";"BBB";"CCC";"DDD"},2)&
INDEX({"AAA";"BBB";"CCC";"DDD"},3)&
INDEX({"AAA";"BBB";"CCC";"DDD"},4)


--ron