Concatenates ranges of cells in Excel, with optional formatting and delimiters. This CONCATENATERANGE formula is a better alternative to TEXTJOIN because it works in all Excel versions, and can use cell formats to format the result. Once installed, you can join cell ranges by using the CONCATENATERANGE formula. The formula syntax is =CONCATENATERANGE(delimiter, ignore_empty, use_formats, range1, range2, etc..), where 'delimiter' is a characters(s) that separates each concatenated item, 'ignore_empty' can be TRUE or FALSE to exclude empty cells, 'use_formats' can be TRUE or FALSE to use each cell's format when displaying the result. You can concatenate as many ranges (or single cells) as you like! The name of the product is 'Concatenate Range' and a free trial can be downloaded at TumblingWaveSoftware.com !
