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.

Starting this tool

Additional keywords to help you find 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

Tip:Alt+P for the previous tool.