Excel help

M

mark

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.
 
R

roadkill

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
 
D

Dave Peterson

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

Dave Peterson

Sorry, I thought you had three columns.

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


Dave said:
=a1&", "&b1&" "&text(c1,"00000")
or
=a1&", "&b1&" "&text(c1,"[>99999]00000-0000;00000")
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.
Click to expand...
Click to expand...
 
Top