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