CLR wrote...
Very nice Duke.........and it even works with non-contiguious ranges as well,
which I like very much. I would ask tho, if it could be modified to allow
the user to select the cell for the concatenation to be placed in each time,
maybe by pop-up, rather than the location being hard coded in.
....

Gee, maybe even make it a udf (like the hundreds of arbitrary
concatenation UDFs that've been posted over the years). If the udf used
a ParamArray argument to allow for variable number of arguments, it'd
only be limited by formula length since it could be called repeatedly,
i.e., =udf(...)&udf(...)&...&udf(...).