Combine contents of two columns of text into one column of text?

Hi, I'm non-programming savvy, basic user of Excel. I have two columns of address information -- city and zip -- and I'd like to combine them into one column. I've searched around online and learned of the "concatenate" function, but only know how to use it for one row at a time and my table has hundreds of rows. I'm guessing that I'll need to devise some macro or to come up with some VBA language to do this? I've never actually used VBA so it seems a bit daunting.

Any help very appreciated.

Thanks!

You can enter Concatenate function in one row and drag it to all the rows or double click on the edge of cell containing first function will fill the same function in all the rows if rows are continuous.

Use it for one row...and drag the formula down to the last row

Oh fantastic! Thanks so much

Hi,

If you are satisfied with the answer, can yo please mark the thread as solved.