Skip to main content

Easily join cell values with specific delimiter in Excel

Author: Siluvia Last Modified: 2024-12-05

Kutools for Excel

Boosts Excel With 300+
Powerful Features

Excel provides several functions to concatenate text from multiple cells such as the CONCATENATE function, the TEXTJOIN function or the & symbol. This article is going to show you a handy formula ā€“ Values are connected with specified characters of Kutools for Excel. With this formula, you can easily join text from multiple cells with specific characters without manually handling formulas.

shot-concatenate-text-from-cells-1

Join cell values with specific delimiter

Please do as follows to join multiple cell values into one in Excel.

1. Select a blank cell to output the result.

2. Click Kutools > Formula Helper > Formula Helper.

shot-concatenate-text-from-cells-2

3. In the Formulas Helper dialog box, configure as follows.

3.1) In the Choose a formula list box, select Values are connected with specified characters;
Tips: Check the Filter box, enter relative characters or words to filter needed formula.
3.2) In the Range box, select a range of cells to be joined;
3.3) In the Character(s) box, enter a delimiter or select the cell containing a delimiter for separating the combined data;
Note: The delimiter is used to separate the joined texts. It can be a text string, one or more characters.
3.4) Click OK.

shot-concatenate-text-from-cells-3

Then texts in selected cells are concatenated into one cell as the below screenshot shown.

shot-concatenate-text-from-cells-4

Notes:

1. This feature is only available for Office 2019 and Office 356.
2. Kutools formulas are grouped into 5 types. By default, all formulas are listed in the Choose a formula box. You can choose a formula type in the Formula Type drop down list to only list formulas of this formula type in the Choose a formula box.

shot-concatenate-text-from-cells-5

3. You can click Kutools > Formula Helper > Text > Connected value by specific character (string) to enable the feature directly.

shot-concatenate-text-from-cells-6

Productivity Tools Recommended

Office Tab: Use handy tabs in Microsoft Office, just like Chrome, Firefox, and the new Edge browser. Easily switch between documents with tabs ā€” no more cluttered windows. Know more...

Kutools for Outlook: Kutools for Outlook offers 100+ powerful features for Microsoft Outlook 2010ā€“2024 (and later versions), as well as Microsoft 365, helping you simplify email management and boost productivity. Know more...

Kutools for Excel

Kutools for Excel offers 300+ advanced features to streamline your work in Excel 2010 ā€“ 2024 and Microsoft 365. The feature above is just one of many time-saving tools included.

šŸŒ Supports 40+ interface languages
āœ… Trusted by 500,000+ users and 80,000+ businesses worldwide
šŸš€ Compatible with all modern Excel versions
šŸŽ 30-day full-featured trial ā€” no registration, no limitations
Kutools for Excel RibbonKutools for Excel Ribbon