How do I combine the contents of two columns?
If "123" is in A2 and "Main Street" is in B2, then in another column enter
=A2&" "&B2
If you want St. instead of Street, select column, then use Edit Replace
to change it.
Hope this helps,
Hutch
"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.
|