Excel - Copy info from several cells into one cell
Issue
I have several sheets in Excel, i.e. Sheet 1, Sheet 2 and Sheet 3. I wanted that A1 cell from Sheet 1 to copy any value that has both A1 cell from Sheet2 and A1 cell from Sheet 3.
Or this if is possible:
- If A1 cell from Sheet2 has any value to insert "text1" into A1 cell from Sheet 1 and if A1 cell from Sheet3 has any value to insert "text2" into A1 cell from Sheet 1.
Solution
In any empty cell in any sheet
type this formula
=Sheet1!A1&Sheet2!A1&Sheet3!A1
Related
- Excel - Copy info from several cells into one cell
- Excel - Copy down formula if cells non-blank » How-To - Excel
- Excel - delete info from a cell found in anot (Solved) » Forum - Excel
- Copy info from several cells into one cell (Solved) » Forum - Excel
- Formula to copy data from one cell [Solved] » Forum - Office software
- Excel - Link data from one cell to another » How-To - Excel