Instructions – version 1.0

Table of Contents

How to install

How to use

How to adjust security

How to uninstall

Version 1.0

Go to version 2.0

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(delimiter, ignore_empty, use_formats, range1, [range2], …)

Note: Excel may not show this formula, because it is custom. However, if you type it, it will work correctly.

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.

range1:
Cell range to be joined (e.g. A1:B2).

[range2, …]:
Additional cell ranges to be joined (e.g. D3), if desired. 

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 commas, and format their display, 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 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:
  1. Click Yes:
  1. Click OK:

That’s it!

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