Not that I'm questioning the formula, or putting Roger down...
But apparently the spaces do have some effect on the end result...

As I've said for many years computers and their functions boil down to two
things... 1's for on, true or working... and 0's for off, false and not
working...

I appreciate all the help from everyone who offered a hand...


"Gord Dibben" wrote:

Our formulas were basically the same.

Mine had a couple of extra spaces for clarity only.

=A1 & " " & B1

Roger left them out.

=A1&" "&B1

No difference in function.


Gord

On Sun, 29 Jul 2007 10:00:01 -0700, 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
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