Select many values in some cells quickly

Copper Contributor

Hi all! 

I'm trying to use the CONCATENATE function joining some cells. Sometimes are 2 cells, other times 10 cells. I've to select all them one by one clicking and writing the symbol ; between the cells. 

¿Does there is anyway to do it faster? 

 

Thank you in advance!

1 Reply

@blackwolf88 , if you are Office 365 subscriber you may use TEXTJOIN