How to combine two columns into a new column

R

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

Spiky

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