LEAVEALPHA

The LEAVEALPHA function removes all non-alphabetic characters from a specified text item.

You can use LEAVEALPHA to remove non-alphabetic characters such as symbols or numbers from a text item.

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

LEAVEALPHA returns a string containing only the alphabetic characters (for example, A-Z and a-z) in text_to_change.

Examples

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

    Returns: AbC

Related functions

  • ISALPHA
  • ISLOWER
  • ISNUMBER
  • ISUPPER
  • LEAVEALPHANUM
  • LEAVENUM
  • LEAVEPRINT