I have a column of e-mail addresses and want to combine every value in the
column into one cell, separated by a semicolon (;) so I can send a mass
e-mail. I have tried using the concatenate function and copying down the
column next to my e-mail column, but can't seem to get this to work.

Here is what I have:
=CONCATENATE(N36,"; ",N35)

I thought if I combine the cell above and then copy down, it should build on
the previous cell, but it isn't working.

Thanks for any help.