Delete all text characters in selected cells

Text > Remove all letters in selection (A-Za-z)

This utility will remove all letters from the values in the selected cells. All letters of the alphabet, both upper and lower case, 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 "8011" .

Screenshot

Launch this tool

Click YLC Utilities > Text > Remove all letters in selection (A-Za-z) :

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" .