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 one (B2), separated with a semicolon and a space - without doing all this manually. Any suggestions?
I know this formula =A2&"; "&A3 - but how do I do this all the way down to A99?
Thanks in advance!
- Doro13Copper Contributor
Okay, I think I found the answer myself:
=TEXTJOIN("; ", TRUE, A2:A99)
:)