Copy 2 cells to 1 cell
BigGuy wrote:
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.
--
They're great. Absolutely fabulous.
We don't blame you one bit for flaunting them.
|