Try this in C1:
=A1&" "&B1
HTH
Jason
Atlanta, GA
-----Original Message-----
I have a column of address numbers that needs to combine
with street names so
that I have a combined column of a complete address.
Example - What I have
in column A is "24513" and in column B I have "Main
Street". So I need to
combine all of column A with all of column B so that all
the addresses appear
in one column as "24513 Main Street"
.
|