Forum Discussion

Doro13's avatar
Doro13
Copper Contributor
Dec 11, 2018

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! 

  • Doro13's avatar
    Doro13
    Copper Contributor

    Okay, I think I found the answer myself: 

     

    =TEXTJOIN("; ", TRUE, A2:A99)

     

    :) 

Resources