How to combine two columns?
 

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.

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

"Robert Judge" wrote:

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.