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
 
Top