Description by the Publisher
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 !
Limitations in the Downloadable Version
Stops working after 3 days
Unique Product ID: PID-3100112B82D5
Unique Publisher ID: BID-660046CD5F9C