How do you  combine parts of address from different cells into one cell?
 Click on the down arrow and select column by column from the drop-down list. Select a delimiter if you want to have the combined cell values separated. 