Instructions

Overview

Concatenate Range lets you join ranges of cells in Excel.

How To Install

  1. To install Concatenate Range, first download the free trial.
  2. 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:

  1. (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:
  1. Click the large button containing the computer icon:
  1. After the install completes, there is a prompt – click OK:

That’s it!

How To Use

  1. Open your Excel workbook.
  2. In your desired cell, type the following formula:

=CONCATENATERANGE(delimiterignore_emptyuse_formatstext1[text2], …)

Note: Excel will not show this formula, because it is a custom formula.

The arguments of the formula are as follows:

delimiter:
An optional text string that will separate the concatenated items. For example, a comma (,).

ignore_empty:
If TRUE (the default), empty cells are ignored.

use_formats:
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.

text1:
Text item to be joined. It can be a text string, or array of strings, such as a range of cells.

[text2, …]:
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:

That’s it!

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:

  1.  Open Microsoft Excel, then click the Office button, then click Options (your version may differ):
  1. In the left pane, select Trust Center, then click Trust Center Settings…:
  1. 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:
  1. Close and re-open Office.
  2. If prompted to enable two Concatenate Range add-ins, click Enable this add-in…, then click OK:

That’s it!

If you still experience issues, you may need to uninstall then re-install Concatenate Range, or contact us.

How To Uninstall

To remove Concatenate Range from your computer::

  1.  
    • For Windows 7 and higher: Go to Control PanelProgramsPrograms and Features. Right-click Concatenate Range, then select Uninstall/Change;
    • For Windows XP: Go to Control PanelAdd or Remove Programs, select Concatenate Range, then click Change/Remove:
  1. Click Yes:
  1. Click OK:

That’s it!

Having trouble? Try our FAQ Support section or contact us!