# Text to Columns

> `UiPath.Excel.Activities.Business.TextToColumnsX`

`UiPath.Excel.Activities.Business.TextToColumnsX`

Splits the text from a cell, range, or table into different columns. The activity can be used with an Excel file selected for a parent [Use Excel File](https://docs.uipath.com/activities/other/latest/productivity/excel-application-card) activity or with the Project Notebook.

## Configuring the activity

#### In the body of the activity

* **Source** - Select **Plus** on the right side of the field, and then, from the menu, select **Indicate in Excel** to indicate the column that contains the text to split. Alternatively, you can select **Custom Input** to enter a range or table name manually, or **Open in Advanced Editor** to enter a VB expression.
* **Destination** - Select **Plus** on the right side of the field, and then, from the menu, select the sheet or the table where you want the split data to appear, or select **Indicate in Excel** to indicate directly from the file. Alternatively, you can select **Custom Input** to enter a range, table name, or sheet name manually, or **Open in Advanced Editor** to enter a VB expression.
* **Data type** - Select the data type from the drop-down menu, **Delimited** (the data is separated by certain characters) or **Fixed width** (the data is separated in groups of a certain number of characters).
  + For **Delimited**, configure the following:
    - **Delimiter** - Select the characters that separate the data: **Tab**, **Semicolon**, **Comma**, **Space**, **Line Break**, or **Other**. By default, all the options except Line Break and Other are selected. If you select Other, enter a value in the **Other delimiter** field.
    - **Consecutive operators as one** - If selected, it indicates the data contains delimiters with multiple characters. This option is selected by default.
    - **Text qualifier** - Select the character that encloses text in your data. Text between two consecutive text qualifiers is treated as one value. The options in the drop-down menu are None (the default selection), Single quote, and Double quote.
  + For **Fixed width**, select **Plus** on the right side of the **Number of characters per column** field, and then, from the menu, select **Number** and enter the number of characters. Alternatively, you can indicate a cell in Excel or select **Open in Advanced Editor** and enter a VB expression.

#### Properties panel

**Common**

* **DisplayName** - The name displayed for the activity in the Designer panel.

**Input**

* **Destination** - See **Destination** in the body of the activity.
* **Source range** - See **Source** in the body of the activity.

**Misc**

* **Private** - If selected, the values of variables and arguments are no longer logged at Verbose level.

**Options**

* See the options for **Data type** in the body of the activity.