Calc KEEPNUMBERS function

For a full list of available calculation functions, please read What calculation functions are supported.

Description

The KEEPNUMBERS function is used to extract only the numeric characters from a given string. This is useful when you want to clean up a string by removing all non-numeric characters.

Syntax

KEEPNUMBERS(text)

The KEEPNUMBERS function syntax has the following argument:

• text - Required. The text string from which you want to extract numeric characters.

Example

Errors

For a full list of formula errors, please read Formula errors.

Related functions

• Calc CHAR function
• Calc CLEAN function
• Calc CODE function
• Calc CONCAT function
• Calc DETECTLANGUAGE function