Join Selected Values Horizontally with a Delimiter...

ASAP Utilities › Columns & Rows › 5. 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

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!

Tip: Easy ways to combine the contents of multiple cells

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 › 5 Join Selected Values Horizontally with a Delimiter...

Additional keywords for this tool:
Join cell values, Combine multiple cells into one, Concatenate cell contents, Merge cell data with delimiter, Consolidate cell values, Merge cells tool, Combine text from adjacent cells, Text join, Merge and consolidate cell contents, Combine cell information with separators, Join strings in Excel

Choose your language preference below

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

Insert Visual Breaks Between Groups in a Column...

Join Selected Values Vertically with a Delimiter...

Download

©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.