How to combine two columns?

G

Guest

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.
 
G

Guest

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 do I combine two EXCEL columns? 4
How to combine two columns into a new column 2
Match Names in columns then copy associated info from 2 sheets 4
How to Replace numbers and text with numbers only? 11
Concatenating Two Columns 4
MID, LEFT, RIGHT help 5
combining columns on the worksheet 1

Top