View Single Post
  #2   Report Post  
Jason Morin
 
Posts: n/a
Default

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"
.