How to copy/paste cell data into existing cell data? - GoFuckYourself.com

srockhard · 02-08-2014, 11:12 PM

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 · 02-08-2014, 11:42 PM

Here is an example:

<----have that....need this---->

Rochard · 02-08-2014, 11:52 PM

copy and paste.

srockhard · 02-08-2014, 11:54 PM

Quote:

Originally Posted by Rochard

copy and paste.

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

EddyTheDog · 02-09-2014, 12:11 AM

Quote:

Originally Posted by srockhard

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 · 02-09-2014, 12:24 AM

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

EddyTheDog · 02-09-2014, 12:41 AM

= CONCATENATE (A1,B1)

Put that in C1

EddyTheDog · 02-09-2014, 12:59 AM

Quote:

Originally Posted by 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 · 02-09-2014, 07:03 AM

Quote:

Originally Posted by EddyTheDog

= 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 · 02-09-2014, 07:09 AM

Quote:

Originally Posted by lagcam

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 · 02-09-2014, 10:38 AM

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

lagcam · 02-09-2014, 07:59 PM

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.

02-08-2014, 11:12 PM	#1
srockhard Retired Industry Role: Join Date: Jul 2011 Location: PDXXX Posts: 1,976	How to copy/paste cell data into existing cell data? 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? __________________ Piper Pines

02-08-2014, 11:42 PM	#2
srockhard Retired Industry Role: Join Date: Jul 2011 Location: PDXXX Posts: 1,976	Here is an example: <----have that....need this----> __________________ Piper Pines

02-08-2014, 11:52 PM	#3
Rochard Jägermeister Test Pilot Industry Role: Join Date: Dec 2001 Location: NORCAL Posts: 73,146	copy and paste. __________________ “The choice is no longer between right or left. The choice is between normal and crazy.” - Sarah Huckabee Sanders YNOT MAIL \| THE BEST ADULT MAILING SOLUTION

02-09-2014, 12:24 AM	#6
izombie Confirmed User Industry Role: Join Date: Sep 2013 Location: Florida Posts: 346	Add them together in column C, do the formula =A1&B1 and so on and it will add the first two columns together. __________________ ICQ - 650889934

02-09-2014, 12:41 AM	#7
EddyTheDog Just Doing My Own Thing Industry Role: Join Date: Jan 2011 Location: London, Spain, New Zealand, GFY - Not Croydon... Posts: 25,040	= CONCATENATE (A1,B1) Put that in C1 Last edited by EddyTheDog; 02-09-2014 at 12:43 AM..

02-09-2014, 10:38 AM	#11
srockhard Retired Industry Role: Join Date: Jul 2011 Location: PDXXX Posts: 1,976	Much love to the GFY guys...works like a charm! __________________ Piper Pines

02-09-2014, 07:59 PM	#12
lagcam Confirmed User Industry Role: Join Date: Jul 2007 Posts: 2,892	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. __________________ Working Cam site for sale - NOT affiliate.