How do I add Concatenate Range to my Excel?

To install Concatenate Range, you can follow the steps on our Instructions page.

How do I use Concatenate Range?

To use Concatenate Range, you can follow the steps on our Instructions page.

When I try to install, I get this message: “The app you’re trying to install isn’t a Microsoft-verified app”.

Windows is “blocking” the downloaded file. To un-block the file, follow steps 1-2 of the install instructions.

When I try to install, I get this message: “Windows protected you PC. Microsoft Defender SmartScreen prevented an unrecognized app from starting. Running this app might put your PC at risk.”

Windows is “blocking” the downloaded file. To un-block the file, follow steps 1-2 of the install instructions.

I don’t see the CONCATENATERANGE formula!

It is normal to not see the CONCATENATERANGE formula, because it is a custom formula. However, if you type the formula, it will work perfectly fine.

I don’t see the arguments for the CONCATENATERANGE formula!

It is normal to not see the arguments for the CONCATENATERANGE formula, because it is a custom formula. However, if you type the formula, it will work perfectly fine.

I purchased a license key, but I am not being prompted to enter it.

The trial version prompts for a license key every six times or so. So, keep using the trial version until you are prompted to enter your key.

  The CONCATENATERANGE formula gives me #NAME?

• Concatenate Range is not (fully) installed – follow the steps in our Instructions page to install Concatenate Range.
• Excel has not loaded The Concatenate Range add-in – to fix, open Excel, select the File menu (or Office button), click Options, Add-ins, then select COM Add-ins from the dropdown, then click Go.., ensure twCONCATENATERANGE is checked, then click OK. Then select Excel Add-ins from the dropdown (if available), then click Go.., If CONCATENATERANGE is in the list, ensure it is checked, then click OK. Restart Excel.

When I try to install Concatenate Range, I get this message: “This setup requires .NET Framework 4.5.2 to be installed. To install, go to: https://dotnet.microsoft.com/download/dotnet-framework/net452”

1. Download and install the .NET Framework 4.5.2.
2. Install Concatenate Range as normal.

When I try to install Concatenate Range, I get this message: “For Windows XP: Install version 1.0 of ‘Concatenate Range’ from: TumblingWave.com/concatenate-range”

1. Click the ‘Download version 1.0’ link on the Concatenate Range page.
2. Follow the instructions to install version 1.0.

When I try to install Concatenate Range, I get this error: “Setup cannot continue because some system files are out of date on your system. Click OK if you would like setup to update these files for you now. You will need to restart Windows before you can run setup again. Click cancel to exit setup without updating system files.”

• For version 2.0 of Concatenate Range, the .NET Framework version 4.5.2 is required.
• For version 1.0 of Concatenate Range, run Windows Update to ensure you have .NET Framework 1.1 or higher.

The CONCATENATERANGE formula gives me #VALUE!

You are trying to pass a bad argument to the CONCATENATERANGE formula – to fix, follow the instructions on how to use Concatenate Range.

I get an invalid/expired license message, but I am still in the free trial period (or have purchased Concatenate Range)!

• Your Windows user security is too restrictive on your PC – Concatenate Range was tested using default Windows security. Contact us for more information.
• Your Windows user is not the user who installed the trial version. The trial version only works for the user who installed the trial version.

Nothing happens when I try to use the CONCATENATERANGE formula!

Your security may be too restrictive – to fix, go to the Instructions page and follow the steps to configure security.

Excel 2007 crashes while using Concatenate Range.

This is a known issue with the trial version 2.0 in Excel 2007. You can do one of the following:

• Remove version 2.0. Then, install version 1.0 by clicking the ‘Download version 1.0’ link on this page.
• Or, you can upgrade your version of Excel.

I am having other issues. I can’t get this to work!

Feel free to e-mail Tumbling Wave Support. If you received an Error Code (e.g. Error Code: V9.9-E9999-L99), please include the Error Code in the e-mail.