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