J.E. McGimpsey has a User defined function that will concatenate cells.

You can find it at:
http://www.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

John McGimpsey has something on his web site that might be what you're
looking for:

http://www.mcgimpsey.com/excel/udfs/multicat.html

Hi,
   Is it possible to concatenate multiple cells that are in consecutive
cols and in the same row without having to input each cell reference:- in
other words is there something similar to =SUM but for text.

=CONCATENATE (A1: W1) does not work but what does?

Many thanks
Nor Par

"Norwegian Parrot" <nor_par@wol.co.za> wrote...

As others have responded, only with VBA. While JE McGimpsey's multicat
function works with ranges, as you seem to want in this instance, it's not
as general as SUM. It could be, but it'd require dispensing with its
optional separator argument. Also, it won't work with arrays.

For a general function as much like SUM as possible, you could try the one
shown in

http://groups-beta.google.com/group/microsoft.public.excel.worksheet.functions/m
sg/94456a9e326b19a6?dmode=source&hl=en

(or http://makeashorterlink.com/?Z6B425D1B ).