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

[chrusa]

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 combine 2 formulas in excel

=A2&" "&B2 (Combine words from different cells into one cell)

Add Cells Across Sheet

='All Clients APPT TEST'!E8+'All Clients GROUP TEST'!E2+'All Clients SCHOOL TEST'!E2+'All Clients Outside APT TEST'!E2

I would like to display multiple words from different cells on different sheets in one cell on one sheet

I have tried this and its not working

='All Clients APPT TEST'!E8&" +'All Clients GROUP TEST'!E2&" +'All Clients SCHOOL TEST'!E2&" +'All Clients Outside APT TEST'!E2&"

Any idea on how to do this?

Thanks

[#2 · Accepted solution]

@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?

[#3]

Yes! Thanks so Much!