Sorry, I misread that part.

Twan Kennis wrote:

Unfortenately MultiCat() is NOT a standard Excel-function, which I asked
for.
By using VBA it's peanuts to create such a function, but without, its a
brain-breaker, or even impossible ...?!

"Dave Peterson" wrote in message
...
J.E. McGimpsey has an =MultiCat() that works like =sum() works with
numbers:
http://mcgimpsey.com/excel/udfs/multicat.html

If you're new to macros, you may want to read David McRitchie's intro
at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Twan Kennis wrote:

Is there a way to concatenate cell-vaues by a given range without
using
VBA of external add-ins, like:

=CONCAT(A1:A3000)

instead of

=CONCATENATE(A1;A2;A3; ................................;A3000)

Thanx in advance.

Greets, Twan

--

Dave Peterson

--

Dave Peterson