Displaying words from multiple cells in multiple sheets in 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

 

[Fluff]

Are you trying to add the values, or concatenate them?

 

[Fluff]

If you are trying to concatenated them, then try

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