How to combine two columns into a new column

  • Thread starter Thread starter Robert Judge
  • Start date Start date
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.
 
For reference, that is the shorthand for the concatenate function.
Longhand:
=CONCATENATE(A1," ",B1)
 
Back
Top