How to Remove Special Characters in Google Sheets


You can use the following formulas to remove special characters in Google Sheets:

Method 1: Remove Everything Except Letters

=REGEXREPLACE(A1,"[^A-Za-z]+","")

Method 2: Remove Everything Except Letters & Numbers

=REGEXREPLACE(A1, "[^0-9a-zA-Z]", "")

Method 3: Remove Specific Special Characters

=REGEXREPLACE(A1, "[!$%]", "")

The following examples show how to use each formula in practice.

Example 1: Remove Everything Except Letters

We can use the following formula to remove everything except letters from a cell:

=REGEXREPLACE(A2,"[^A-Za-z]+","")

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

remove special characters in Google Sheets

Notice that every special character and number has been removed from the original values.

All that we’re left with are the letters from each cell.

Example 2: Remove Everything Except Letters & Numbers

We can use the following formula to remove everything except letters and numbers from a cell:

=REGEXREPLACE(A2, "[^0-9a-zA-Z]", "")

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

Notice that every special character has been removed from the original values.

All that we’re left with are the letters and numbers from each cell.

Example 3: Remove Specific Special Characters

We can use the following formula to remove specific special characters from a cell:

=REGEXREPLACE(A2, "[!$%]", "")

This particular formula removes the following special characters from a cell:

  • !
  • $
  • %

Note that you can add as many specific special characters as you’d like between the brackets in the REGEXREPLACE() formula.

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

Notice that every exclamation point (!), dollar sign ($), and percentage sign (%) has been removed from the original cell.

All other values from the original cell are kept.

Additional Resources

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

How to Round to Significant Figures in Google Sheets
How to Find the Closest Value in Google Sheets
How to Extract Numbers from String in Google Sheets

Leave a Reply

Your email address will not be published.