Forum Discussion
Doro13
Dec 11, 2018Copper Contributor
Merge contents of several cells in one cell
Hi people! I've got a question I wasn't able to find an answer to using the search function... I want to merge the content of several cells (A2, A3, A4 etc. all the way down to A99) into on...
Doro13
Dec 11, 2018Copper Contributor
Okay, I think I found the answer myself:
=TEXTJOIN("; ", TRUE, A2:A99)
:)