Concatenation

[Norwegian Parrot]

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

 

[Dave Peterson]

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

 

[RagDyeR]

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

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

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

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

 

[Harlan Grove]

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?

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...tions/msg/94456a9e326b19a6?dmode=source&hl=en

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