Download and install the free add-in Morefunc.xll from:
http://xcell05.free.fr/

then use this formula

=MCONCAT(IF(A1:A28<"",A1:A28))



"HARSHAWARDHAN. S .SHASTRI" wrote:

Is it possible to concatenate group of cells. i e for exp if cell a1
contains "a" and cell a28 contains "z" . What i want is a formula which will
results in to abcd----xyz.

Harshawardhan . Shastri

India