Tip of the Day | Saturday November 29th, 2025
Discover new tools to get things done.
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
Starting this tool
- Click ASAP Utilities › Columns & Rows › 7. Join Selected Values Vertically with a Line Break Separator
- Specify a Keyboard Shortcut: ASAP Utilities › My Tools & Shortcuts › Manage My Tools & Shortcuts...
Choose your language preference below
English (us) ⁄ Nederlands ⁄ Deutsch ⁄ Español ⁄ Français ⁄ Português do Brasil ⁄ Italiano ⁄ Русский ⁄ 中文(简体) ⁄ 日本語
©1999-2025 ∙ ASAP Utilities ∙ A Must in Every Office BV ∙ The Netherlands
🏆 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.
🏆 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.