May 04 2022 10:15 AM
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.
May 04 2022 10:27 AM
Solution=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?
May 04 2022 10:30 AM
May 04 2022 10:27 AM
Solution=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?