How to Remove Percentage Symbol in Excel (With Example)


You can use the following formula to remove the percentage symbol ( % )from a cell in Excel:

=SUBSTITUTE(A2, "%", "")*100

This particular formula removes the percentage symbol from the value in cell A2.

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

Example: Remove Percentage Symbol in Excel

Suppose we have the following list of percentages in Excel:

Suppose we would like to remove the percentage symbol from each value in column A.

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

=SUBSTITUTE(A2, "%", "")*100

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

Excel remove percentage symbol

Column B now displays each of the values in column A with the percentage symbol ( % ) removed.

How This Formula Works

Recall the formula that we used to remove the percentage symbol:

=SUBSTITUTE(A2, "%", "")*100

This function first uses the SUBSTITUTE function to substitute the percentage symbol in cell A2 with nothing.

For cell A2, this produces the value 0.123.

We then multiply by 100 to get the value 12.3.

The result is that we’re able to remove the percentage symbol and still be left with the original value from the cell.

Note that the value that results from this formula is in a General number format:

This means we can still perform numerical calculations using this value if we’d like.

Additional Resources

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

Excel: How to Remove Specific Text from Cells
Excel: How to Remove Special Characters
Excel: How to Remove Last 3 Characters from String

Featured Posts

Leave a Reply

Your email address will not be published. Required fields are marked *