CleanDigits function for LibreOffice Calc

CLEANDIGITS() Description

The CLEANDIGITS() function is designed to clean text from all characters except numbers.

Main Features Functions CLEANDIGITS




Example Usage

The CLEANDIGITS() function is easy to use. You just need to type any text and LibreOffice Calc will automatically clean it of all characters except numbers:


We will have the following result:

CLEANDIGITS formula usage

This example uses the following values:

Extension "YouLibreCalc.oxt"

You can use the function CLEANDIGITS() by setting the extension " YouLibreCalc.oxt ". After that, this function will be available in all files that will be opened in LibreOffice Calc.