How to combine two columns?

R

Robert Judge

I have received an EXCEL file that has two columns containing address
information. One column has the street number (for instance 6, 123, etc.)
and the second column has the Street name (Main, Elm, etc.)

In Excel 2003, how can I combine these two columns into one column to give
me, in the one column:
6 Main St.
123 Elm St.
 
L

Leigh Ann

in a new column, use the formula: =A1&" "&B1 which will give you a join of
the two coumns with a space between the number and street name.

LAT
 

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

How do I combine the contents of two columns? 4
How to center adjust text above and image in a two column document. 1
How do I combine two EXCEL columns? 4
How to combine two columns into a new column 2
Two columns : Continuous two columns vs Parallel two Column 1
Match Names in columns then copy associated info from 2 sheets 4
MID, LEFT, RIGHT help 5
Parsing one part of an address 4

Top