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


Feedback