Concatenate a Range of Excel Cells With a Delimiter

Sep
24

Here is how to easily concatenate a range of cells in Excel with a specified delimiter:

=JOIN(", ", A2:A148)

You can change the delimiter (", ") to be anything that you want. A2:A148 are the starting and ending cells of the range.