Excel Formulas to Remove the Unwanted Characters ~ Easy Tricks!!

Sometimes, you need to remove all the unwanted characters from the text strings in Excel. This article provides some quick tricks to achieve this job. Let’s get into this article!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

General Formula:

You can use the below formula to remove unwanted characters in Excel.

=SUBSTITUTE(A1,CHAR(code),””)

Syntax Explanations:

*SUBSTITUTE * – This function can replace existing text with new text in a text string when you want to replace text based on its content, not position. Read more on the SUBSTITUTE ** function**.
CHAR – In Excel, the CHAR function helps to get a character by a specified number.
*A1 * – It represents the input value.
Comma symbol (,) – It is a separator that helps to separate a list of values.
Parenthesis () – The main purpose of this symbol is to group the elements.

Example:

Refer to the below example image.

Here we will enter the input values in Column B.
Now we are going to delete all the unwanted characters from the text string.

Select any cell and type the above-given formula.

Finally, press the ** ENTER** key, you can get the result as shown below.

Closure:

From this tutorial, you can get some clarification on how to remove all the unwanted characters in Excel. Hope you like this article. If you have any issues regarding this article or any unresolved queries , please comment in the comment box below. We will assist you.

Thank you so much for visiting *Geek Excel!! **If you want to learn more helpful formulas, check out Excel Formulas *!! **