Delete all text characters in selected cells

Text > Remove all letters in selection

This utility will remove all letters from values in selected cells. All letters of the alphabet, both uppercase and lowercase, will be removed from each cell in your selection. Cells with formulas will be skipped.

For example, a cell with a value "8011LB" will be replaced by "8011" .

Screenshot

Running this tool

Click YLC Utilities > Text > Remove all letters in selection :

How much time will this save?

Using this tool will definitely save you time and effort. However, the actual time savings will depend on how often you use it. Excel , the amount of data you work with, and how often you use the tool.

Download extension

You can use the utility Remove all letters in selection by installing the extension YLC Utilities .

After that, this function will be available in all files that are opened in Excel .