Concatenate a Range of Excel Cells With a Delimiter


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.

Tags: #Excel Author: Seth Westphal
comments powered by Disqus