Concatenate Text

Combine two lists with an option to add a custom prefix, suffix, and separator. This is useful when you want to join or merge two text documents line by line.

Concatenate first names and surnames, with space as a separator.

Sarah
Anthony
William
Steven

Mitchell
Edwards
Johnson
Davis

Sarah Mitchell
Anthony Edwards
William Johnson
Steven Davis

When enabled, the tool will not add the specified prefix, suffix, and/or separator when both lines are empty.

• Split Text - Split a text into individual columns, or by a new line.
• Extract Column - Get a specific column from a delimited text.
• Swap Columns - Swap two columns from a delimited text.