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
- Excel conditional formatting if another cell contains any text ✓ - Forum - Excel
- Excel vba copy row if cell value matches ✓ - Forum - Office Software
- Excel duplicate rows based on cell value ✓ - Forum - Excel
- Excel create rows 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).
