TOP

CleanDigits function for LibreOffice Calc

YLC Utilities logo

CLEANDIGITS() Description

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


Main Features Functions CLEANDIGITS

Syntax:

=CLEANDIGITS(Text)

Parameters:

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:

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.