CleanDigits function for Excel

CLEANDIGITS() Description

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

Main Features Functions CLEANDIGITS

Syntax:

=CLEANDIGITS(Text)

Parameters:

• Text: Text that needs to be cleaned of non-numeric characters.

Example Usage

The CLEANDIGITS() function is easy to use. You just need to enter any text and Excel automatically clear 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 extension

You can use the function CLEANDIGITS() by installing the extension YLC Utilities .

Or its free version YouLibreCalc .

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