Merge contents of several cells in one cell

Copper Contributor

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! 

1 Reply

Okay, I think I found the answer myself: 

 

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

 

:)