Combine a List into One Cell with Semicolons in Excel
Question details
Combine values from a list into one cell, separated by semicolons and spaces.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A user has a list of text values in separate cells and wants a single semicolon-separated result.
- Observed behavior
- The desired result is one cell containing values such as Abc.Def; Xyz.Mno; Pqrs.Tuv.
Identify the cells containing the list and choose an empty cell outside that range for the result. The examples below use C2:C4 as the source range.
Use TEXTJOIN to combine the list and skip blank cells
Use this method in Microsoft 365 or Excel 2019 and later to join a range while ignoring empty cells.
Click an empty cell outside C2:C4 where you want the combined list to appear.
Type =TEXTJOIN("; ",TRUE,C2:C4) in the selected cell. Replace C2:C4 with your list's range if needed.
Press Enter. Excel joins the nonblank values with a semicolon and space between them.

Use ampersands to combine a short list
Use this approach for a small, fixed list when TEXTJOIN is unavailable.
Join a List with Semicolons in WPS Spreadsheets
Open your workbook in WPS Spreadsheets and use TEXTJOIN to combine list values into one cell while skipping blanks.
- 1. Open the workbook: Open WPS Spreadsheets and select Open to load your Excel workbook.
- 2. Select an output cell: Click an empty cell outside the list range.
- 3. Enter TEXTJOIN: Type =TEXTJOIN("; ",TRUE,C2:C4), replacing C2:C4 with your source range.
- 4. Show the combined list: Press Enter to display the semicolon-separated values in the selected cell.

Frequently Asked Questions
How do I skip blank cells when joining a list?
Use TRUE as the second argument in =TEXTJOIN("; ",TRUE,C2:C4). The formula ignores empty cells in the selected range.
Can I combine a longer list with the same formula?
Yes. Change C2:C4 to the full range, such as C2:C100, and enter the formula in a cell outside that range.
What can I use if my Excel version does not have TEXTJOIN?
For a short list, enter a formula such as =C2&"; "&C3&"; "&C4 in an empty cell. It will include separators even when referenced cells are blank.
How do I change the separator?
Replace the text in the first TEXTJOIN argument. For example, =TEXTJOIN(", ",TRUE,C2:C4) uses a comma and space instead.




