Concatenate Range lets you join ranges of cells in Excel.
How To Install
- To install Concatenate Range, first download the free trial.
- As with all downloaded files, ensure the zip file is unblocked: right-click ConcatenateRange.zip, select Properties, and if you see an Unblock button, click Unblock, then OK:
3. Unzip the ConcatenateRange.zip, then run the setup.exe file:
- (You may be prompted to update your system files – if so, run Windows Update to ensure you have .NET Framework 1.1 or higher.) Click OK:
- Click the large button containing the computer icon:
- After the install completes, there is a prompt – click OK:
How To Use
- Open your Excel workbook.
- In your desired cell, type the following formula:
=CONCATENATERANGE(delimiter, ignore_empty, use_formats, text1, [text2], …)
Note: Excel will not show this formula, because it is a custom formula.
The arguments of the formula are as follows:
An optional text string that will separate the concatenated items. For example, a comma (,).
If TRUE (the default), empty cells are ignored.
If TRUE, the result will be formatted (e.g. a currency value of “1” will display as $1.00, etc).
If FALSE (the default), no formatting is applied.
Text item to be joined. It can be a text string, or array of strings, such as a range of cells.
Additional text items to be joined. Each can be a text string, or array of strings, such as a range of cells.
EXAMPLE #1 – Concatenating ranges of cells with formatting
If we have two cell ranges, A1:B2 and D3, as follows:
we can concatenate these values, separated by a comma, and retain their formatting, as follows:
EXAMPLE #2 – Concatenating ranges of cells without formatting
To concatenate the values from EXAMPLE #1 without formatting, we change the formula as follows:
How To Adjust Security
If you have our software installed but it is not working as expected, your Office security settings may need to be configured:
- Open Microsoft Excel, then click the Office button, then click Options (your version may differ):
- In the left pane, select Trust Center, then click Trust Center Settings…:
- In the left pane, select Add-ins. Uncheck Disable all Application Add-ins. It is recommended to also uncheck Require Application Add-ins to be signed by Trusted Publisher, otherwise you will be prompted to enable the Concatenate Range add-in:
- Close and re-open Office.
- If prompted to enable two Concatenate Range add-ins, click Enable this add-in…, then click OK:
How To Uninstall
To remove Concatenate Range from your computer::
- For Windows 7 and higher: Go to Control Panel, Programs, Programs and Features. Right-click Concatenate Range, then select Uninstall/Change;
- For Windows XP: Go to Control Panel, Add or Remove Programs, select Concatenate Range, then click Change/Remove:
- Click Yes:
- Click OK: