Hi Alex
one way:
1. download the free add-in Morefunc.xll . It includes the
function
MCONCAT (http://longre.free.fr/english/)

2. Use the formula
=MCONCAT(A1:E1,", ")

-----Original Message-----
CONCATENATE accepts only single cells.

How can I concatencate contiguos cells (a range of
strings) without writing each cell reference by hand?

Only via VBA? And how?

Thank you Alex.

.