Q: I have one column of street numbers and another column of street names. How can I put them together into another new column?

A: If your street number is in cell A1 and your street name is in cell A2, you could put this in A3 to merge them together:

=A1 & " " & A2

This is called STRING CONCATENATION. Now, Excel is going to try to play with your formula as you're entering it. Don't let it. Abort any kind of AutoComplete that pops up and just type in what I showed you above.

Subscribe to Excel: String Concatenation
Get notifications when this page is updated