| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
In Excel can you merge two columns i.e. street numbers and addres.
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? |
|
#2
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
