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

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" wrote in message
...
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

=a1& " " & b1
and drag down.



sttrumpet wrote:

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

--

Dave Peterson