Delete all the numbers in the selected cells

Text > Remove all digits in selection (0-9)

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

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

Screenshot

Launch this tool

Click YLC Utilities > Text > Remove all digits in selection (0-9) :

How much time will it save?

Using this tool, you are guaranteed to save time and effort. However, the actual time savings depends on how often you use LO Calc, the amount of data you are working with, and how often you use the tool.

Download

If you don't already have YLC Utilities, you can download the free version "YouLibreCalc.oxt" or the full-featured version "YLC_Utilities.oxt" .