combining columns on the worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 2 columns of information that I want to combine/merge into 1 column. Column A contains street numbers and column B contains the name of the street. How do I merge or combine the two so that show as one column containing with combined info? ie: 130 Main St
 
Donna, here is one way =A1&" "&B1

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **
donna said:
I have 2 columns of information that I want to combine/merge into 1
Click to expand...
column. Column A contains street numbers and column B contains the name of
the street. How do I merge or combine the two so that show as one column
containing with combined info? ie: 130 Main St
 
Back
Top