Hi,

With a choice between
=A1&" "&B1
and
=CONCATENATE(A1," ",B1)
I would opt for the first one ontil Microsoft allows us to use it like this:
=CONCATENATE(A1:B1)

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Robert Judge" wrote:

I have two columns in Excel 2003 containing address information:

Column 1 Column 2
123 Main Street

How can I combine these into a new column that will state "123 Main St."?

I will appreciate advice.