I don't think you can do that...

I use an helper column
Enter
=A1 in B1
Enter
=B1 & ", ", A2 in B2
and copy down...

Last cell gives me the concatenation of all cells in Col A, upto that row.

"Garth" wrote:

I just learned about the CONCATENATE function and it seems like what I need
but I often have a good number of cells to pick my data from. Is there a way
to select a range of cells, like A1:A5, in lieu of selecting each individual
cell A1,A2,A3,A4,A5 ?