logo ASAP Utilities

The ASAP Utilities menu in Excel (English)

Excel with ASAP Utilities in its menu

Merge column data (join cells)...

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

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:
  • Delimiter to put between the cell values
  • Skip empty cells
  • Use the value, formula or formatted value from the cells.

    You can use this utility as a quick alternative to Excel's =CONCATENATE() function.


    Example screenshot: Merge cell contents of selected columns into one cell
    Merge cell contents of selected columns into one cell
    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  ›  5 Merge column data (join cells)...
    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

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

    Empowering Excel Users Worldwide for 25 Years