Text to Columns Activity

The Text to Columns activity splits the content of a single-column cell range into multiple columns based on a specified delimiter. This is particularly useful for reporting processes where pulled data (such as combined date/time strings or delimited values) needs to be separated into individual, addressable cells.

Field	Description	Requirement
Excel name	The reference name of the Excel file, which must already be open or created, is selected from a dropdown.	Required
Sheet name	The name of the Excel sheet to work within. If not specified, the activity defaults to the first sheet.	Optional
Sheet index	The index of the Excel sheet to work within. If not specified, the activity defaults to the first sheet.	Optional
Range	The single-column range of cells whose content will be split (e.g., `A1:A20`).	Required
Delimiter	The character used to determine where each cell's content should be split (e.g., a space or a comma).	Required
Destination cell	The starting cell where the resulting columns will be written. If left blank, the split columns overwrite the original range.	Optional

Action Types & Examples

Delimiter-Based Split

Format: string
Example Result: "."

Implementation Examples

Field Setup - Excel name: ${newExcel} - Sheet name: Sheet1 - Range: A1:A20 - Delimiter: - Destination cell: B1

Execution Parameters - Sheet index: 1

Technical Notes

The activity splits each cell in Range on every occurrence of Delimiter, placing each resulting fragment into an adjacent column starting at Destination cell. This is useful for separating combined values such as a dd.mm.yyyy hh.mm.ss date/time string into individual date and time columns.