Excel help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
=a1&", "&b1&" "&text(c1,"00000")
or
=a1&", "&b1&" "&text(c1,"[>99999]00000-0000;00000")
 
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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need VLOOKUP to Work Two Ways 0
Move rows into columns 3
change row to column 1
Formula to Separate City, State, Zip 6
How to merge Excel address columns when some zips begin with zeros 4
Primary and Secondary tech locator 1
How do I make a vertical report export into a vertical report? 3
Offset function with inconsisent data location 1

Back
Top