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.