logo ASAP Utilities

The ASAP Utilities menu in Excel (English)

Excel 365, 2021, 2019, 2016, 2013, 2010 or 2007 with ASAP Utilities in its menu

Merge column data (join cells)...

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

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

    Screenshots

    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

    In the Excel menu choose: ASAP Utilities  ›  Columns & Rows  ›  Merge column data (join cells)...

    Download
    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
    Detect and visualize adjacent data/group changes...



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