Appending data to existing rows

Hello guys,

I need some help here.. I have 2 questions

1. I have 2 spreadsheets and i am trying to append the data(from spreadsheet2) to the end of data in rows into spreadsheet 1

Here is where I want it
http://screencast.com/t/nZnuenp97

Spreadsheet2
http://screencast.com/t/fkViEhGy0O

I can easily copy and paste from spread 1 to 2 but can't get it to paste at the end of the existing data in spread 1..


Question # 2

Is there any way to move data from the end of the rows to another place in the same row..
I want to move the numbers on the end to where the red arrows are pointing (Behind the word halco)
http://screencast.com/t/LOWccl3AbUq

Please advise..

Thanks, Dan

In answer to questions 1, there is an easy way to do this by using a formula.

If the Data was on Sheet 1 Cell B2 and Sheet 2 Cell D5, Then you can simply find a blank Cell say Cell C2 to begin your formula. =((select Cell B2) & " " & (select cell D5). This would combine the cells and then you could copy and paste special over the old data.

If this works, press the star at bottom left.

-Rich

In answer to Question #2, Yes. Assuming you had cell A1 that said 2012ABCD. If you want to parce that Cell Data and grab just the first 4 digits on the left you could type in cell A2 =Left(A1,4) and it would give you 2012. If you wanted the right 4 characters from A1 you could type in cell A3, =Right(A1,4) which would return ABCD.

Does this help?

Question 2, you can use the text to columns feature and then do what I said in #1 Or you could type in a blank cell say D3, =Left(C3,6) & Right(C3,6) assuming that your data was in Column C and copy down.

Sorry guys I am new to the formulas so i am not sure how to do this

Please attach your file or tell me what cells your data is in.