CleanDigits function for LibreOffice Calc

CLEANDIGITS() Description

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

Main Features Functions CLEANDIGITS

Syntax:

=CLEANDIGITS(Text)

Parameters:

• Text: Text to be cleared of non-numeric characters.

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:

=CLEANDIGITS("(508)453-56-78")

We will have the following result:

This example uses the following values:

• Text: A3 - Text to clear ("(508)453-56-78") .

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.