Merging Columns
In C1 enter =A1 & " " & B1
Double-click on fill handle of C1 to copy down.
Gord Dibben MS Excel MVP
On Sun, 29 Jul 2007 08:06:02 -0700, Titanium
wrote:
I am trying to 'make one' a number of columns...
Essentially I have several thousand rows of data that I need to clean up...
What I would like to accomplish is Column A + B = AB
Column A Data: I need this one first
Column B Data: and this one comes right behind with a space for proper grammer
To equal one column: I need this one first and this one comes right behind
with a space for proper grammer.
Thanks in advance for any input!
Ti
|