LEAVENUM

The LEAVENUM function removes all non-numeric characters from a text item. For example, you can use LEAVENUM when you want to remove all alphabetic characters and symbols from a text string.

Syntax:
LEAVENUM (single-text-expression)
Meaning:
LEAVENUM (text_to_change)
Returns:
A single text item

LEAVENUM returns a string containing only the numeric characters (for example, 0-9) in text_to_change.

Examples

  • LEAVENUM ("A-b-C-1$3")

    Returns: 13

Related functions

  • ISALPHA
  • LEAVEALPHA
  • ISLOWER
  • LEAVEALPHANUM
  • ISNUMBER
  • LEAVEPRINT
  • ISUPPER