If city and state are in A1 and zip is in A2 and you want the combination in
A3, put the following in A3:

=A1 & " " & A2

You can then copy the formula in A3 down for however many rows you have.
Will

"mark" wrote:

I am trying to combine 2 columns of data. The first column contains city and
state, while the second column contains zip code. I'd like a new column to
contain city, state and zip code.