excel help

[jmosbaugh]

Perhaps I can get an answer here. I'd really appreciate it.

I've got 37000 rows of column A and column B

I want to concatenate A to B for all the rows.

my formula is =CONCATENATE(A1,B1)

how can I apply this formula in column C so that it will automatically
iterate for each row? I can paste it in for each row and change the
A1,B1 to A2,B2... A3,B3 etc, but that's impossible.

There's got to be a simple way.

thank you in advance!

 

[jmosbaugh]

found the answer, drag the lower right hand corner of the cell with the
function it down and it calculates automatically.