How do you combine two columns to one?

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

Guest

I have a column of address numbers that needs to combine with street names so
that I have a combined column of a complete address. Example - What I have
in column A is "24513" and in column B I have "Main Street". So I need to
combine all of column A with all of column B so that all the addresses appear
in one column as "24513 Main Street"
 
Correction, that should be...

C1, copied down:

=A1&" "&B1

Hope this helps!
 
You must log in or register to reply here.

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

Word Create a Phone Book using MailMerge in word 2007 0
How do you combine two columns to one? Help!!!!!! 2
Move alternating cells 6
How do I compare the stored data in micro 3
how do i merge the datas in 2 columns 3
counting blank cells within two columns 2
How to join row data into one row 1
How to combine two different excel files 1

Back
Top