Concatenate Text


Add this at the beginning of each line

Add this at the middle of each line

Add this at the end of each line

About


You can combine two lists and add a prefix, a suffix, and a separator that you choose. This is helpful when you want to join or merge two text documents line by line.

Basic Example


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

Column 1
Sarah
Anthony
William
Steven
Column 2
Mitchell
Edwards
Johnson
Davis
Result
Sarah Mitchell
Anthony Edwards
William Johnson
Steven Davis

Exclude Empty Lines


When this option is turned on, the tool won't add the prefix, suffix, or separator you've chosen when both lines are empty.

Related Tools


  • 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.