Instructions

Table of Contents

How to install

How to use

How to adjust security

How to uninstall

Version 1.0

SPLIT TEXT XL

Splits text to columns or rows in Excel.

How To Install

  1. To install Split Text XL, first download the free trial.
  2. Ensure the downloaded file is not being “blocked”, as follows:
    • a ) From Windows File Explorer, go to your “Downloads” folder.
    • b ) Right-click the SplitTextSetup.zip file, select Properties.
    • c ) If you see an Unblock checkbox, check Unblock, then OK:

3. Unzip the SplitTextSetup.zip file, then open the SplitTextSetup.msi file. Click Next:

  1. If you agree, check I accept the terms of the License Agreement, then click Next:
  1. If desired, click Change… to change the install folder. Click Next:
  1. Click Install:
  1. Click Finish:

That’s it!

How To Use

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

=SPLITTEXT(expression, delimiter, text_to_columns)

Note: Excel may not show this formula or its arguments. However, if you type it, it will work perfectly.

The arguments of the formula are as follows:

expression:
String expression containing substrings and delimiters.

delimiter:
String character used to identify substring limits.

text_to_columns:
To split text to columns, set to TRUE (the default); To split to rows, set to FALSE.

EXAMPLE

If cell A2 contains “John Smith”, you could split his first and last name into two columns, as follows:

=SPLITTEXT( A2 , ” ” , TRUE )

click to zoom EXAMPLE

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 select the File menu, 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 SplitText add-in:
  1. Close and re-open Office.
  2. If prompted to enable the SplitText add-in, click Enable this add-in…, then click OK:

That’s it!

If you still experience issues, you may need to uninstall then re-install Split Text XL, or contact us.

How To Uninstall

To remove Split Text XL from your computer:

  1.  In Windows, go to Add or remove programs:
  1. Scroll and select Split Text XL, then click Uninstall:

That’s it!

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