Combine Cells

[info-]

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? 

[#2]

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

[#3]

Does that work for text as well? @Riny_van_Eekelen 

[#4]

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

[#5]

@info- Yes!