How to remove numbers from text strings in Excel?

When working with Excel, it's common to encounter text strings that contain unwanted numbers mixed in with letters or other characters. Cleaning up your text by eliminating digits ensures consistency and improves readability. This guide provides a detailed walkthrough of several practical solutions, ranging from Excel formulas to a convenient Kutools for Excel utility, as well as a custom VBA User Defined Function. Each method is designed to help you efficiently strip numbers from text strings based on your preferred workflow and the size of your dataset.

• Remove numbers from text strings with a formula
• Batch remove numbers from text strings with Kutools for Excel
• Remove numbers from text strings with User Defined Function
• Alternative solutions: Flash Fill and Text to Columns

---

Remove numbers from text strings with a formula

If you prefer solutions that rely solely on Excel's built-in functions, you can use the following array formula. This method is especially valuable for users who need a formula-based approach and want to avoid using add-ins or macros. Keep in mind, however, that such array formulas tend to be long and may seem complicated for beginners, and can be less optimal for very large datasets due to performance considerations.

1. Select the cell where you want the cleaned text to appear, for example, cell C2.
2. Enter the following array formula into the selected cell and press Ctrl + Shift + Enter to confirm:
   

   =TEXTJOIN("", TRUE, IF(ISNUMBER(--MID(A2, ROW(INDIRECT("1:" & LEN(A2))), 1)), "", MID(A2, ROW(INDIRECT("1:" & LEN(A2))), 1)))

   
   In the formula, "A2" refers to the cell containing your original text string. If your data is in another cell, please adjust the reference accordingly before pressing Ctrl + Shift + Enter.

3. After applying the formula, click the result cell. Use the Fill Handle - the small square at the bottom-right corner of the cell - to drag and fill the formula down for the rest of your data range.

   

Tips and Troubleshooting:

• This formula is case-insensitive and will remove any digit from the text string, leaving letters and other non-digit characters intact. It will not remove spaces or punctuation - only numbers.
• Always check the formula output for accidental formatting issues; copying and pasting the formula or dragging it across merged cells may produce unexpected errors.
• If you see a #VALUE! error after entering the formula, double-check that you have pressed Ctrl + Shift + Enter, not just Enter.

---

Batch remove numbers from text strings with Kutools for Excel

When dealing with very large datasets or requiring a high level of convenience, the "Remove Characters" feature in Kutools for Excel can save significant time and effort. This automated tool allows you to delete numeric characters from multiple cells in one batch operation, offering speed and simplicity for both routine tasks and one-time cleanups. Kutools seamlessly integrates into Excel, providing an accessible interface to streamline your workflow and reduce errors associated with manual processing.

1. First, select all cells containing text strings where you want to remove numbers.

2. Then navigate to the Kutools tab, click "Text", and select "Remove Characters" from the dropdown menu.

3. Within the "Remove Characters" dialog box, check the "Numeric" option. This ensures only numbers will be deleted from your text string cells. Next, click "OK" to apply the removal.

   

The result is immediate: all selected cells are cleansed of numeric characters.

Additional Tips:

• If your data includes not only numbers but also symbols or other unwanted marks, you can further refine the cleanup by checking the "Non-alpha" option in the dialog. This will preserve only alphabetic characters, helping standardize text.

  

• The last Kutools action can be undone using Excel’s Undo command. However, actions performed earlier with Kutools cannot be undone once a new operation is executed, so it’s a good practice to save your workbook before applying multiple Kutools features.

Demo: remove numbers from text strings in Excel

---

Remove numbers from text strings with User Defined Function

If you're comfortable using code, creating a VBA User Defined Function (UDF) lets you automate the removal of numbers and reuse the logic in any workbook. This method is flexible and works well for customized extraction tasks, repeated cleaning processes, or cases where formula limitations prevent batch processing.

1. Press Alt + F11 on your keyboard to open Excel’s VBA editor.

2. In the VBA window, go to Insert > Module. Paste the following VBA code into the module area:

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

3. Close the VBA editor and return to Excel. In a blank cell (for example, cell B2 or wherever you’d like the cleaned text), enter this formula:

   =RemoveNumbers(A2)

   Remember to replace "A2" with the cell reference containing your original text string. The UDF will then remove all numbers from the specified cell.

   

Things to Keep in Mind:

• Your workbook must be saved as macro-enabled (*.xlsm) after adding VBA code, otherwise the function will not work on reopening.
• VBA solutions suit those looking for reusable, customized logic, but require enabling macros in Excel for security reasons.
• If you receive an error such as #NAME?, double-check that the code has been entered and saved correctly in your VBA module, and that macros are enabled.
• This VBA method works on both small and large datasets; you can use it in formulas and extend it to other cells as needed.

---

Alternative solutions: Flash Fill and Text to Columns

For quick, visual manual cleanup - especially when data structure is predictable - Excel provides Flash Fill and Text to Columns, which are useful for simple cases or data preparation:

• Flash Fill: Type the desired result (with numbers removed) next to your original cell, then press Ctrl + E to auto-fill similar transformations. This is ideal if the removal pattern is consistent and easy to identify. For more details, see Flash Fill in Excel.
• Text to Columns: If numbers always appear in the same position or are separated by delimiters, you can use Data > Text to Columns to split columns and then combine only the non-number parts. This approach works best for structured data, such as codes or labels. For more details, see How to separate text and numbers from one cell into two columns.

Each method above has its own strengths; formula and VBA approaches allow for automation, while Kutools offers efficiency and ease of use in bulk operations. Manual tools like Flash Fill are best for smaller, visually manageable datasets or quick fixes.

---

Related articles:

---