SOLVED

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

%3CLINGO-SUB%20id%3D%22lingo-sub-3309139%22%20slang%3D%22en-US%22%3ECombine%20Words%20from%20Multiple%20sheets%20and%20cells%20into%20one%20cell%20on%20one%20sheet%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3309139%22%20slang%3D%22en-US%22%3E%3CP%3EHello%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20combine%20words%20from%20multiple%20cells%20across%20multiple%20sheets%20into%20one%20single%20cell%20onto%20one%20sheet.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBasically%20trying%20to%20combine%202%20formulas%20and%20am%20unsuccessful.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CDIV%20class%3D%22%22%3ETrying%20to%20combine%202%20formulas%20in%20excel%3C%2FDIV%3E%3CDIV%20class%3D%22%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22%22%3E%3DA2%26amp%3B%22%20%22%26amp%3BB2%20(Combine%20words%20from%20different%20cells%20into%20one%20cell)%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3EAdd%20Cells%20Across%20Sheet%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3D'All%20Clients%20APPT%20TEST'!E8%2B'All%20Clients%20GROUP%20TEST'!E2%2B'All%20Clients%20SCHOOL%20TEST'!E2%2B'All%20Clients%20Outside%20APT%20TEST'!E2%3C%2FDIV%3E%3CDIV%20class%3D%22%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22%22%3EI%20would%20like%20to%20display%20multiple%20words%20from%20different%20cells%20on%20different%20sheets%20in%20one%20cell%20on%20one%20sheet%3C%2FDIV%3E%3CDIV%20class%3D%22%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22%22%3EI%20have%20tried%20this%20and%20its%20not%20working%3C%2FDIV%3E%3CDIV%20class%3D%22%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22%22%3E%3D'All%20Clients%20APPT%20TEST'!E8%26amp%3B%22%20%2B'All%20Clients%20GROUP%20TEST'!E2%26amp%3B%22%20%2B'All%20Clients%20SCHOOL%20TEST'!E2%26amp%3B%22%20%2B'All%20Clients%20Outside%20APT%20TEST'!E2%26amp%3B%22%3C%2FDIV%3E%3CDIV%20class%3D%22%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22%22%3EAny%20idea%20on%20how%20to%20do%20this%3F%3C%2FDIV%3E%3CDIV%20class%3D%22%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22%22%3EThanks%3C%2FDIV%3E%3CDIV%20class%3D%22%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3309139%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3310223%22%20slang%3D%22en-US%22%3ERe%3A%20Combine%20Words%20from%20Multiple%20sheets%20and%20cells%20into%20one%20cell%20on%20one%20sheet%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3310223%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1381052%22%20target%3D%22_blank%22%3E%40chrusa%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3E%3DCONCATENATE('All%20Clients%20APPT%20TEST'!E8%2C%22%20%22%2C'All%20Clients%20GROUP%20TEST'!E2%2C%22%20%22%2C'All%20Clients%20SCHOOL%20TEST'!E2%2C%22%20%22%2C'All%20Clients%20Outside%20APT%20TEST'!E2)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3EDoes%20this%20formula%20work%20in%20your%20sheet%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3310499%22%20slang%3D%22en-US%22%3ERe%3A%20Combine%20Words%20from%20Multiple%20sheets%20and%20cells%20into%20one%20cell%20on%20one%20sheet%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3310499%22%20slang%3D%22en-US%22%3EYes!%20Thanks%20so%20Much!%3C%2FLINGO-BODY%3E
New Contributor

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 Replies
best response confirmed by Grahmfs13 (Microsoft)
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?