LEAVEALPHANUM

The LEAVEALPHANUM function removes all non-alphanumeric characters (such as symbols) from a specified text item.

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

LEAVEALPHANUM returns a string containing only the alphanumeric characters (for example, A-Z, a-z and 0-9) in text_to_change.

Examples

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

    Returns: AbC13

Related functions

  • ISALPHA
  • LEAVEALPHA
  • ISLOWER
  • LEAVENUM
  • ISNUMBER
  • LEAVEPRINT
  • ISUPPER