CleanDigits function for Excel

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 enter any text and Excel will automatically clean it of all characters except numbers:

=CLEANDIGITS(Text)

We will have the following result:

This example uses the following values:

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

Download the extension

You can use the CLEANDIGITS() function by installing a free extension YouLibreCalc.xlam .

After that, this function will be available in all files that will be opened in Excel.