Tip of the Day | Monday 8 June 2026

Discover new tools to get things done.

Join Selected Values Vertically with a Delimiter...

This tool merges data from the rows in your selection by joining adjacent cell values vertically into the top cell of each column.
In doing so, the data from the lower rows is removed and consolidated into the top cell of reach column.
You can customize the process by specifying a delimiter to insert between the cell values.

This tool is a quick alternative to Excel's CONCATENATE(), CONCAT(), or TEXTJOIN() functions.

Tip:
Try our =ASAPMERGECELLS() function for even more flexibility in combining values.

Starting this tool

Click ASAP Utilities › Columns & Rows › 6. Join Selected Values Vertically with a Delimiter...

Specify a Keyboard Shortcut: ASAP Utilities › My Tools & Shortcuts › Manage My Tools & Shortcuts...

Example screenshot: Combine the data from the rows in your selection (Here's the English version.)