HOW DO I COMBINE WHOLE COLUMNS NOT USING THE CELL FORMULA?

[Tory]

I need to combine whole columns from B2-B1912 and C2-C1912. I've tried the
formula =B2&" "&C2 and then draging to copy and paste special, but I'm
getting nowhere. I even chage the maximum allowed iterations. HELP!
Tory

 

[Gary Smith]

I need to combine whole columns from B2-B1912 and C2-C1912. I've tried the
formula =B2&" "&C2 and then draging to copy and paste special, but I'm
getting nowhere. I even chage the maximum allowed iterations. HELP!
Tory

Perhaps I don't understand what you're trying to do, but if you enter the
formula =B2&" "&C2 in cell D2, select D2, and double-click on the small
black square (fill handle) in the bottom right corner of the cell, the
formula will be copied down the entire column. That should give you what
I believe you want. Dragging the cell down the column also works, but is
difficult to do with that many rows. Paste special isn't needed here.