Delete all numbers in selected cells

Text > Remove all digits in selection

This utility removes all digits from values in selected cells. The digits 1, 2, 3, 4, 5, 6, 7, 8, 9, and 0 will be removed from each cell in your selection. Cells with formulas will be skipped.

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

Screenshot

Running this tool

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

Excel:

LibreOffice Calc:

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 (Calc) , the amount of data you work with, and how often you use the tool.

Download the extension

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

After that, this function will be available in all files that are opened in Excel (LibreOffice Calc) .