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


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.

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 enabled, the tool will not add the specified prefix, suffix and/or separator 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.