Author: Oscar Cronquist Article last updated on February 04, 2019

Joining multiple cell values in Excel is not easy, for example, the CONCATENATE function allows you to only reference a single cell in each argument.

Formula in cell B6:

=CONCATENATE(B2,B3,B4,C2,C3,C4)

Press and hold CTRL to quickly select cells you want to concatenate then click on cells you want to be included in the concatenate function.

The CTRL key saves you a little bit of time but not much if you have many cells to join.

The above example works if you don't have so many cells to add. A large range like A1:Z100 would be very tedious to add, clicking on each cell.

What can I do to speed things up? It depends on the Excel version you are using.

What options do I have?

The solutions presented in this article are for earlier versions than Excel 2016 however, if you have Excel 2016 you can now finally use the TEXTJOIN function.