Merging Columns
How so unless your data is not as you originally described it?
A1 = first
B1 = last
A2 = next first
B2 = next last
In C1 using the formula given you will get "first last"
In C2 you will get "nextfirst next last"
Gord
On Sun, 29 Jul 2007 08:56:01 -0700, Titanium
wrote:
This formula does work. However, it uses up two rows...
It merges 1/2 the data appropriately, but fails to merge every other line...
"Roger Govier" wrote:
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
|