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.

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.

=a1&", "&b1&" "&text(c1,"00000")
or
=a1&", "&b1&" "&text(c1,"[99999]00000-0000;00000")



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.

--

Dave Peterson

Sorry, I thought you had three columns.

=a1&" "&text(b1,"00000")
or
=a1&" "&text(b1,"[99999]00000-0000;00000")


Dave Peterson wrote:

=a1&", "&b1&" "&text(c1,"00000")
or
=a1&", "&b1&" "&text(c1,"[99999]00000-0000;00000")

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.

--

Dave Peterson

--

Dave Peterson