How do you combine two columns to one? Help!!!!!!

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

Guest

I have address numbers in column A and street names in column B, I want to
combine all of both columns into one without going through the whole process
for each individual cells. HELP!!!!!!
 
sttrumpet said:
I have address numbers in column A and street names in column B, I want to
combine all of both columns into one without going through the whole process
for each individual cells. HELP!!!!!!
Click to expand...

Use the fuction =A1&B1 in cell B1
Drag the function down
Select Column B and copy
If you want your data to be in column A, selct Paste specail and select
values. Hit OK
If you want a space between number and name, use =A1&" "&B1

/Fredrik
 
=a1& " " & b1
and drag down.


I have address numbers in column A and street names in column B, I want to
combine all of both columns into one without going through the whole process
for each individual cells. HELP!!!!!!
Click to expand...
 
You must log in or register to reply here.

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 you combine two columns to one? 4
counting blank cells within two columns 2
How to combine two different excel files 1
Word Create a Phone Book using MailMerge in word 2007 0
Excel Comparing two columns 1
combining data from two columns into one 1
combine text from two columns to one 4
Combining Content of two cells 2

Back
Top