Thread: Merging Columns
View Single Post
  #14  
Old May 31st, 2010, 09:36 PM posted to microsoft.public.excel.worksheet.functions
vhnbvb
external usenet poster
 
Posts: 1
Default Merging Columns

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
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