Combine Cells

%3CLINGO-SUB%20id%3D%22lingo-sub-2115419%22%20slang%3D%22en-US%22%3ECombine%20Cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2115419%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20to%20combine%20cells%20E2%3AE56%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20tired%20%26amp%3B%20functions%20and%20concat%2C%20how%20would%20I%20create%20the%20formula%20to%20combine%20these%2055%20cells%20into%201%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2115419%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2115482%22%20slang%3D%22en-US%22%3ERe%3A%20Combine%20Cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2115482%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F956690%22%20target%3D%22_blank%22%3E%40info-%3C%2FA%3E%26nbsp%3BYes!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2115469%22%20slang%3D%22en-US%22%3ERe%3A%20Combine%20Cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2115469%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F956690%22%20target%3D%22_blank%22%3E%40info-%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20you%20simply%20want%20to%20concatenate%20all%20the%20values%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DCONCAT(E2%3AE56)%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20you%20want%20to%20concatenate%20them%20with%20a%20separator%2C%20e.g.%20value1%2C%20value2%2C%20value3%2C%20...%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DTEXTJOIN(%22%2C%20%22%2CTRUE%2CE2%3AE56)%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EBoth%20formulas%20work%20only%20if%20you%20have%20Excel%202019%20or%20Excel%20in%20Microsoft%20365.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2115465%22%20slang%3D%22en-US%22%3ERe%3A%20Combine%20Cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2115465%22%20slang%3D%22en-US%22%3E%3CP%3EDoes%20that%20work%20for%20text%20as%20well%3F%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2115459%22%20slang%3D%22en-US%22%3ERe%3A%20Combine%20Cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2115459%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F956690%22%20target%3D%22_blank%22%3E%40info-%3C%2FA%3E%26nbsp%3BIf%20you%20are%20on%20a%20recent%20Excel%20version%20(2019%20or%20later)%20use%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-markup%22%3E%3CCODE%3E%3DTEXTJOIN(%22%22%2CTRUE%2CE2%3AE56)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3BChoose%20whatever%20delimiter%20you%20want%20and%20put%20it%20between%20the%20quotation%20marks.%20Otherwise%20leave%20it%20as%20above.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I need to combine cells E2:E56 

I have tired & functions and concat, how would I create the formula to combine these 55 cells into 1? 

4 Replies

@info- If you are on a recent Excel version (2019 or later) use:

 

=TEXTJOIN("",TRUE,E2:E56)

 

 Choose whatever delimiter you want and put it between the quotation marks. Otherwise leave it as above.

Does that work for text as well? @Riny_van_Eekelen 

@info- 

If you simply want to concatenate all the values:

 

=CONCAT(E2:E56)

 

If you want to concatenate them with a separator, e.g. value1, value2, value3, ...:

 

=TEXTJOIN(", ",TRUE,E2:E56)

 

Both formulas work only if you have Excel 2019 or Excel in Microsoft 365.

@info- Yes!