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

 

 

excel

Resources