In Excel can you merge two columns i.e. street numbers and addres.

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

Guest

In Excel can you merge two columns i.e. street numbers in one and street
names in another so that they come out as one?
 
Have a run at it with this
=CONCATENATE(A2," ",B2)

Place that in C2
A2 would have your street numbers
B2 would have your street names
C2 displays the merged cells.

Pierre
 
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

Match Account ID from combining street names and numbers 1
How to combine two columns into a new column 2
Separate address numbers from street name 4
Word Create a Phone Book using MailMerge in word 2007 0
Need to merge columns 10
Vlookup 1
Comparing/Matching two columns 4
In search of a new Obelisk 6

Back
Top