From: vhnbvb on
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
> > >
> > >
> > >
> >
> >