How auto concatenate many cells?

Hi.   I have 1000 text cells in Excel. I need to concatenate it into one cell. I try to use =CONCATENATE(B1: B999), but it not works. When I try to use some as =CONCATENATE(B1; B999) - it's work,...