Forum Discussion

chrusa's avatar
chrusa
Copper Contributor
May 04, 2022
Solved

Combine Words from Multiple sheets and cells into one cell on one sheet?

Hello   I am trying to combine words from multiple cells across multiple sheets into one single cell onto one sheet.   Basically trying to combine 2 formulas and am unsuccessful.     Trying to...
  • OliverScheurich's avatar
    May 04, 2022

    chrusa 

    =CONCATENATE('All Clients APPT TEST'!E8," ",'All Clients GROUP TEST'!E2," ",'All Clients SCHOOL TEST'!E2," ",'All Clients Outside APT TEST'!E2)

    Does this formula work in your sheet?

Resources