Calc KEEPTEXT function

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

Description

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

Syntax

KEEPTEXT(text)

The KEEPTEXT function syntax has the following argument:

• text - Required. The text string from which you want to extract non-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