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

A

Aaronhaus

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?
 
P

Pierre

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
 

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

Merging from an Excel file with graphics 1
comapering two sheets in excel 2010 0
Match Account ID from combining street names and numbers 1
How to Sort and Address 1
Merge Excel file into Word Document 3
How to combine two columns into a new column 2
Separate address numbers from street name 4
How do you alphabetize street addresses within a column? 4

Top