Excel - Copy info from several cells into one cell

March 2017




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


Published by aakai1056.
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).