combining columns on the worksheet

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
 
P

Paul B

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I combine the contents of two columns? 4
How do I combine two EXCEL columns? 4
How to combine two columns into a new column 2
combining column content 8
How to combine two columns? 1
Word Create a Phone Book using MailMerge in word 2007 0
Match Account ID from combining street names and numbers 1
combining two columns 5

Top