Try

=A1 &" "& B1

Drag down as required

Mike

"Robert Judge" wrote:

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.