How to combine two columns into a new column

[Robert Judge]

I have an EXCEL 2003 workbook that contains addresses. The "Street Number"
is in one column and the "Street Name" is in another column, like this:

Column A Column B
123 Main Street

I would like to combine the data in these two columns into a new, third
column that would look like this:


Column C

123 Main Street

How can I accomplish this? I will appreciate advice.

 

[Mike H]

Try

=A1 &" "& B1

Drag down as required

Mike

 

[Spiky]

For reference, that is the shorthand for the concatenate function.
Longhand:
=CONCATENATE(A1," ",B1)