Concatenate Range

Infocard

Target Platform: Windows Version: 2.0 Release Date: October 7, 2019 License: Shareware Price: USD 19.99 Publisher: Tumbling Wave Software Product Web Site: [External Link]

Concatenates ranges of cells with formatting.

[Download Concatenate Range ver. 2.0]

1.95 Mb

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

Product Identity

Unique Product ID: PID-3100112B82D5

Unique Publisher ID: BID-660046CD5F9C

[Concatenate Range PAD XML File]