concatenate range of cells

Asusming your data is in column A.

=Concatenate(a1,b1,c1,d1) etc

If you want spaces between the data then =Concatenate(a1," ",b1," ",c1," ",d1," ") etc.

That would work great. What about if I had to concatenate 500 cells?

I need to combine these into a group of 500. It would be a real chore to type all those cells into a formula