logo ASAP Utilities

The ASAP Utilities menu in Excel (English)

Excel with ASAP Utilities in its menu

Join Selected Values Vertically with a Line Break Separator

ASAP Utilities  › Columns & Rows  ›  7. Join Selected Values Vertically with a Line Break Separator

This tool merges data from the rows in your selection by joining adjacent cell values vertically, separating them with a line break, 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 each column. 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.

Screenshots

Example screenshot: Merge row data, separate cells by a line break
Merge row data, separate cells by a line break
ASAP Utilities makes YOU rock in Excel!

Practical tricks on how this can help you

Practical 'real world' examples on our blog that show you how this tool can help you in Excel. Enjoy!

Starting this tool


Columns & Rows  ›  7 Join Selected Values Vertically with a Line Break Separator
Additional keywords for this tool:
Merge row data with line breaks, Join row cells with line break separator, Combine row cells with Alt+Enter, Excel merge cells with line breaks, Consolidate row data with line breaks, Join cell contents with a line break, Merge cell contents using CHAR(10), Excel text join with line breaks, Combine multiple cells with line breaks

Choose your language preference below

English (us)NederlandsDeutschEspañolFrançaisPortuguês do BrasilItalianoРусский中文(简体)日本語

Download
Join Selected Values Vertically with a Delimiter...




Home Privacy Policy Cookie Policy EULA Download All added Excel tools Sitemap Contact Us


🏆 Winner of the "Best Microsoft Excel Add-in" Award at the Global Excel Summit 2025 in London!
For over 25 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.