You can use the following formula to remove semicolons from the text in a cell in Excel:

=SUBSTITUTE(A2, ";", "")

This particular formula removes all semicolons from the text in cell **A2**.

The following example shows how to use this formula in practice.

**Example: How to Remove Semicolon from Cells in Excel**

Suppose we have the following list of text values in Excel:

Suppose we would like to remove the semicolons from the text in each cell in column A.

We can type the following formula into cell **B2** to do so:

=SUBSTITUTE(A2, ";", "")

We can then click and drag this formula down to each remaining cell in column B:

Column B displays each text value in column A with the semicolon removed.

If you would instead like to replace the semicolon with a different value, you can specify this value within the **SUBSTITUTE** function.

For example, you could use the following formula to instead replace each semicolon with a space:

=SUBSTITUTE(A2, ";", " ")

The following screenshot shows how to use this formula in practice:

Column B displays each text value in column A with the semicolon replaced by a space.

**Note**: You can find the complete documentation for the **SUBSTITUTE** function in Excel here.

**Additional Resources**

The following tutorials explain how to perform other common tasks in Excel:

Excel: How to Check if Cell Contains Partial Text

Excel: How to Check if Cell Contains Text from List

Excel: How to Count Frequency of Text