How to Remove Numbers from Strings in Google Sheets


You can use the following formula to remove numbers from strings in Google Sheets:

=REGEXREPLACE(A2,"\d", "")

This particular formula will remove all numbers from the string in cell A2.

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

Example: Remove Numbers from Strings in Google Sheets

Suppose we have the following list of employee ID’s for some company in Google Sheets:

Now suppose that we would like to remove all numbers from each ID so that only the letters remain.

We can use the following formula to do so:

=REGEXREPLACE(A2,"\d", "")

We’ll type this formula in cell B2, then drag and fill it down to each remaining cell in column B:

remove numbers from string in Google Sheets

Notice that all numbers have been removed from each string so we’re left with only the letters from each employee ID.

How This Formula Works

The REGEXREPLACE function in Google Sheets is used to replace specific characters in a string based on a regular expression.

Consider the formula we used:

=REGEXREPLACE(A2,"\d", "")

The first argument specifies that we want to replace characters in cell A2.

The second argument of \d is used in regular expressions to match any digit from 0 to 9.

The third argument of a blank string is used to specify that we’d like to replace any digit from 0 to 9 with nothing.

The end result is that each number is simply removed from the string.

Note: You can find the complete documentation for the REGEXREPLACE function here.

Additional Resources

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

How to Extract Substring in Google Sheets
How to Reverse a Text String in Google Sheets
How to Extract Numbers from String in Google Sheets

Featured Posts

One Reply to “How to Remove Numbers from Strings in Google Sheets”

  1. how to remove My name and (months ago) from the values below where 5 changes from 1-12?

    My name 12/12/20 (5 months ago)

Leave a Reply

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