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 duplicate rows based on cell value ✓ - Forum - Excel
- Excel add rows based on cell value - Forum - Excel
- Excel vba find first empty cell in row - How-To - Excel
- Excel send value to another cell - How-To - 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).
Subscribe To Our Newsletter!
