The ASAP Utilities menu in Excel (English)
Merge column data (join cells)...
English (us) ⁄ Nederlands ⁄ Deutsch ⁄ Español ⁄ Français ⁄ Português do Brasil ⁄ Italiano ⁄ Русский ⁄ 中文(简体) ⁄ 日本語Columns & Rows › 5. Merge column data (join cells)...
This utility merges the data from the columns in your selection.For each row in your selection the data from the adjacent columns will be concatenated into the first cell in the row.
You can specify the following:
You can use this utility as a quick alternative to Excel's =CONCATENATE() function.
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!Starting this tool
- Click ASAP Utilities › Columns & Rows › 5. Merge column data (join cells)...
- Specify a Keyboard Shortcut: ASAP Utilities › Favorites & Shortcut keys › Edit your favorite tools and shortcut keys...
Additional keywords for this tool:
merge cell contents, connect strings together, text, separators, combines, consolidation, combine cells of information, combine the contents of multiple cells, concatenate, concatenation, into one cell
merge cell contents, connect strings together, text, separators, combines, consolidation, combine cells of information, combine the contents of multiple cells, concatenate, concatenation, into one cell
©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.