Merge contents of two columns into one?

[Robert Judge]

I have an EXCEL worksheet with two columns containing
address information. For an address of 123 Main St., one
column has the "123" and the second column has the "Main
St."

I want to import this data into Contacts in Outlook
2003. However, my existing street address field in
Outlook Contacts has the information in one column, that
is, "123 Main St."

So, I want to combine the two EXCEL columns into one
column, so I can then import that column into Outlook,
bringing the street address field into Outlook with the
same address format that already exists there.

How can I merge the two columns in EXCEL into the one new
column that I need? I will appreciate advice.

 

[BenjieLop]

If your first cell (house number) is on A1 and the second cell (hous
street) is on B1, see if this works for you:

=A1&""&B1

and copy down as needed.

 

[Alex Delamain]

A1 B1
123 Main st

then c1

=+a1&+" "&+b

 

[Dave Peterson]

I don't think I'd use the plusses:

=a1&" "&b1

should work ok.