You can use the following formula to remove numbers from strings in Google Sheets:
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:
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:
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.
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