This article describes the RPA Excel functionality to split cell contents into multiple columns.

For a full list of available functions, please read EXCEL functions.

Description

The EXCEL Text to columns function splits cell contents into multiple columns based on a delimiter. On Windows, uses Excel's built-in TextToColumns. On macOS, uses a Python-based split.

Setting it up

To use the EXCEL Text to columns function, follow these instructions:

Once on a process map:

Navigate to the process where you would like to add the EXCEL Text to columns function
Click on the green button's drop-down (right side of the green button labelled "Process")
On the menu that appears, click on the "+ Activity" item
From here you can select the EXCEL Text to columns option
Click "Add" once you are done

Input parameters

Parameter	Required	Type	Default	Description
File path	Yes	Text	–	Full path to the Excel file.
Sheet	Yes	Text	–	Name of the sheet.
Source range	Yes	Text	–	Source column range (e.g. A1:A100).
Delimiter	No	Text	,	Delimiter character (defaults to comma).
Destination cell	No	Text	Source	Destination cell (e.g. B1). Defaults to overwriting the source.

Output variables

This action does not produce any output variables.

Errors

Error	Description
File not open	The Excel file must be open.
Sheet not found	The specified sheet does not exist.
Invalid range	The source range is not valid.

Tips

Common delimiters: comma (,), semicolon (;), tab, pipe (|).
Set a destination cell to avoid overwriting the original data.
Ensure there are enough empty columns to the right of the destination to hold the split data.

EXCEL Text to columns function