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 - delete info from a cell found in anot ✓ - Forum - Excel
- How to move info from one cell to another in excel - Guide
- Excel conditional formatting if another cell contains specific text ✓ - Forum - Excel
- Excel return value if another cell contains text ✓ - Forum - Excel
- Excel vba filter based on cell value ✓ - Forum - Excel
This document, titled « Excel - Copy info from several cells into one cell », is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).
