Concatenate Range

From Software Infocard Wiki
Jump to: navigation, search

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.
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 !

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]