concatenate range of cells

[tonyvr4]

Is there a way to concatenate a range of cells?

I have a list of data of about 3000 cells in a column in excel.. I would like to combine these cells in groups of about 500.

Is there any way to accomplish this?
Thanks

[timbo1957]

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.

[tonyvr4]

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

[Huron]

Have a look at NBVC's answer here

http://www.excelforum.com/excel-gene...-function.html