This method will introduce a User Defined Function to remove numbers from text strings easily in Excel. Please do as follows:

1. Press Alt + F11 keys simultaneously to open the Microsoft Basic for Application window.

2. Click Insert > Module, and then paste the following VBA code into the opening Module window.

VBA: Remove Numbers from Text Strings in Excel

Function RemoveNumbers(Txt As String) As String
With CreateObject("VBScript.RegExp")
.Global = True
.Pattern = "[0-9]"
RemoveNumbers = .Replace(Txt, "")
End With
End Function

3. Save the Use defined Function. Select a blank cell that you will return the text string without numbers, enter the formula =RemoveNumbers(A2) (A2 is the cell you will remove numbers from), and then drag the Fill Handle down to the range as you need.

This method will introduce Kutools for Excel’s Remove Characters utility to quickly remove all numbers from text string cells in Excel. Please do as follows:

1. Select the text string cells that you will remove numbers from, and click Kutools > Text > Remove Characters.

2. In the opening Remove Characters dialog box, please check the Numeric option, and click the Ok button.

Then you will see all numbers are removed from selected text string cells at once. See Screenshot:

Note: Sometimes you may need to remove numbers and other special marks from the text string cells, and leave letters only. You can get it done by checking the Non-alpha option and clicking the Ok button in the Remove Characters dialog box. See screenshot:

Quickly extract numbers from text strings with Kutools function in Excel

Kutools for Excel's Kutools Functions utility provides an EXTRACTNUMBERS function to help you quickly extract numbers from mixed text strings with ease.

How to remove letters from strings/numbers/cells in Excel?