Excel Function to Remove All Text OR All Numbers from a Cell

How to create and use a function that removes all text or all numbers from a cell, whichever you want.

To do this, we will create a UDF or User Defined Function in Excel.

But, I won't make you start from scratch; if you want to get the functions right away, simply download the Excel file attached to this tutorial and copy the code for yourself or get it from below.

Sections:

The Functions

How to Install and Use these Functions

Notes

The Functions

If you just want the code and already know what to do with a UDF, here it is.

UDF to Remove All Text from a Cell

UDF to Remove All Numbers from a Cell

How to Install and Use these Functions

In order to get these functions to work, we first need to install them into Excel.

1. Hit Alt + F11 to go to the VBA Editor window.
2. Once there, go to Insert > Module
   
   
3. You will see an empty window like this:
   
4. Paste the code from the previous section into this window:
   
5. Go back to Excel, Alt + F11, and then simply start typing either KillNumbers or KillText into a cell and you should see the functions appear in the function drop down menu.
   Select the desired function and then select the cell that contains the data and hit enter, just like you would enter a regular function in Excel.
   
   
6. You can see the output from both functions here:
   

That's all there is to it!

Notes

To kill the text and numbers from a cell, I created a UDF or User Defined Function. This is basically a macro that allows for the creation of a custom function in Excel.

Check out the tutorial on User Defined Functions in Excel for more information on those.

Make sure to download the sample file attached to this tutorial so you can copy/paste the code with ease and see the examples at work in Excel.