ISALPHA

You can use ISALPHA when you need to know whether a text string is all alphabetic characters.

Syntax:
ISALPHA (single-text-expression)
Meaning:
ISALPHA (text_to_test)
Returns:
This function evaluates to a Boolean "true" or "false" and should only be used as a conditional expression within a logical function.

The ISALPHA function tests a text object to see if it is contains all alphabetic characters.

If text_to_test contains only alphabetic characters (for example, A-Z and a-z), ISALPHA evaluates to "true".

If text_to_test contains other than just alphabetic characters, ISALPHA returns "false".

Examples

  • IF(ISALPHA ("AnywhereUSA"))

    Returns "true"

  • IF(ISALPHA ("Anywhere USA"))

    Returns "false"

  • IF(ISALPHA ("Mr. Brown"))

    Returns "false"

Related functions

  • ISLOWER
  • LEAVEALPHANUM
  • ISNUMBER
  • LEAVENUM
  • ISUPPER
  • LEAVEPRINT
  • LEAVEALPHA