Forum Discussion
chrusa
May 04, 2022Copper Contributor
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...
- May 04, 2022
=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?
OliverScheurich
May 04, 2022Gold Contributor
=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?
chrusa
May 04, 2022Copper Contributor
Yes! Thanks so Much!