Forum Discussion
Combine Cells
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?
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
