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:

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

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)