Thread: Merging Columns
View Single Post
  #2  
Old July 29th, 2007, 04:35 PM posted to microsoft.public.excel.worksheet.functions
Roger Govier[_2_]
external usenet poster
 
Posts: 55
Default Merging Columns

Hi

In C1
=A1&" "&B1
Copy down as far as required.
Copy column CPastes Special back over the formulae to "fix" the values.

--
Regards
Roger Govier



"Titanium" wrote in message
...
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