use CONCATENATE function
or
= A1&" "&B1



On Jan 27, 12:47*am, 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.