Home Screenshots 10 Languages Why use it?

Tip of the Day | Tuesday April 28th, 2026

Discover new tools to get things done. ASAP Utilities makes YOU rock in Excel!

Join Selected Values Horizontally with a Delimiter...

This tool merges data from the columns in your selection by joining adjacent cell values horizontally into the first cell of each row.
In doing so, the data from the cells to the right is removed and consolidated into the first cell in each row.

You can customize the merging process by specifying the following:

A delimiter to insert between cell values

Whether to skip empty cells

Whether to use the cell's value, formula, or displayed value (using the displayed value preserves number formatting such as percentages, decimals, dates, or phone numbers)

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

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

Screenshots

Example screenshot: Merge cell contents of selected columns into one cell

Starting this tool

Click ASAP Utilities › Columns & Rows › 5. Join Selected Values Horizontally with a Delimiter...
Specify a Keyboard Shortcut: ASAP Utilities › My Tools & Shortcuts › Manage My Tools & Shortcuts...

Columns & Rows › Join Selected Values Horizontally with a Delimiter...

Choose your language preference below

English (us) ⁄ Nederlands ⁄ Deutsch ⁄ Español ⁄ Français ⁄ Português do Brasil ⁄ Italiano ⁄ Русский ⁄ 中文(简体) ⁄ 日本語

Today's Tip

Download

©1999-2026 ∙ 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 26 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.