How to copy/paste cell data into existing cell data?

[srockhard]

I'm using open office (likely similar solution for excel) and I need to copy about 1200 rows of data to be appended to the 1200 adjacent columns rows without replacing that columns data. In other words I need to copy data in cell A to cell B so that cell B stays the same just adds A to it.... so cell B would become BA. Any help?

[srockhard]

Here is an example:
<----have that....need this---->

[Rochard]

copy and paste.

[srockhard]

copy and paste.

If I copy column A and past in column B then column B will disappear.

[EddyTheDog]

If I copy column A and past in column B then column B will disappear.

I can do this with my eyes closed - I have had a few drinks though and I am blind...

1+1=7 right?....

[izombie]

Add them together in column C, do the formula =A1&B1 and so on and it will add the first two columns together.

[EddyTheDog]

= CONCATENATE (A1,B1)

Put that in C1

[EddyTheDog]

= CONCATENATE (A1,B1)

Put that in C1

= CONCATENATE (A1,B1)

Put that in C1

Where

A1=cock

B1=http://ccn.com/

C1=http://cnn.com/cock

[lagcam]

= CONCATENATE (A1,B1)

Put that in C1

Where

A1=cock

B1=http://ccn.com/

C1=http://cnn.com/cock

Eddy is right that concatenate is the correct formula to use (well it is in excel anyway) but based on the data on his column contents his formula should have been =concatenate(b1,a1) not as he put it.

I haven't used open office for many years and whilst most excel formulas do work sometimes they need a little tweak so if you can't get concatenate to work, izombie's solution is just as good, namely

1.keep domain data in column a
2.add cocks etc in column b
3. column c type +a1&b1
4. copy column c down the page as far as you need to.

If you want to do this many times with different data you can just copy and paste value (to another column or spreadsheet) your column c data and rinse and repeat over and over

[EddyTheDog]

Eddy is right that concatenate is the correct formula to use (well it is in excel anyway) but based on the data on his column contents his formula should have been =concatenate(b1,a1) not as he put it.

I haven't used open office for many years and whilst most excel formulas do work sometimes they need a little tweak so if you can't get concatenate to work, izombie's solution is just as good, namely

1.keep domain data in column a
2.add cocks etc in column b
3. column c type +a1&b1
4. copy column c down the page as far as you need to.

If you want to do this many times with different data you can just copy and paste value (to another column or spreadsheet) your column c data and rinse and repeat over and over

Oops - Sorry - Don't drink and code folks...

[srockhard]

Much love to the GFY guys...works like a charm!

[lagcam]

I love spreadsheets and concatenate is one of my favourite formulas.

It is very useful for reconciling accounts with huge volume transaction because you can use it to build strings of data which you can then use in conjunction with "match" function.