Copy 2 cells to 1 cell

[BigGuy]

I have 2 spreadsheets and I need to copy 2 cells in 1 spreadsheet into
cell in the other spreadsheet....and I do not know how to do this
Thank

 

[Auric__]

I have 2 spreadsheets and I need to copy 2 cells in 1 spreadsheet into 1
cell in the other spreadsheet....and I do not know how to do this.

Need to tell us exactly what you want to do.

If you just want to concatenate 2 values (stick them together; "1" + "2" =
"12") do this:

='C:\path\to\[file1.xlsx]Sheet1'!A1&'C:\path\to\[file2.xlsx]Sheet1'!A2

If you want to do anything else, clarify.