Function Problems

Combine a List into One Cell with Semicolons in Excel

Huda QurayshiHuda Qurayshi Nov 18, 2026 871 views

Question details

Combine values from a list into one cell, separated by semicolons and spaces.

Combine a List into One Cell with Semicolons in Excel
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.
Before you start

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.

Solution 1Recommended

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.

1
Select an output cell

Click an empty cell outside C2:C4 where you want the combined list to appear.

2
Enter the formula

Type =TEXTJOIN("; ",TRUE,C2:C4) in the selected cell. Replace C2:C4 with your list's range if needed.

3
Display the result

Press Enter. Excel joins the nonblank values with a semicolon and space between them.

Use TEXTJOIN to combine the list and skip blank cells
Blank cells: The TRUE argument tells TEXTJOIN to ignore empty cells.
Combine text in WPS Spreadsheets

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. 1. Open the workbook: Open WPS Spreadsheets and select Open to load your Excel workbook.
  2. 2. Select an output cell: Click an empty cell outside the list range.
  3. 3. Enter TEXTJOIN: Type =TEXTJOIN("; ",TRUE,C2:C4), replacing C2:C4 with your source range.
  4. 4. Show the combined list: Press Enter to display the semicolon-separated values in the selected cell.
Combine list values with a semicolon and space.Ignore blank cells with the TEXTJOIN formula.Open and save Microsoft Excel XLSX files.Work in a familiar spreadsheet interface.
microsoft office alternative - wps office

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.