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
