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

[sttrumpet]

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!!!!!!

 

[Fredrik Wahlgren]

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!!!!!!

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

 

[Dave Peterson]

=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!!!!!!