From: vhnbvb on 31 May 2010 16:36 thank you "Titanium" wrote: > Gord, I could be wrong, but I believe the reason Roger's formula didn't work > for me is because of the spacing. Your formula worked perfectly fine. I do > appreciate the help of both Roger and yourself. You saved me countless hours > of hellish copy & pasting monotony... :) > > "Gord Dibben" wrote: > > > 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 > > <Titanium(a)discussions.microsoft.com> 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 > > > > > > > > > > > > >
|
Pages: 1 Prev: The last day Next: View Message when Mouse Hovers over Cell. (Not the Comments Fe |