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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top