You are here KNOWLEDGE Excel Tips Excel Text, Editing and Format Validating text entries in Microsoft Excel

Query, Share and Manage Excel workbooks on LAN, Internet

Validating text entries in Microsoft Excel

From Data choose Validation.
The Allow box in the Settings tab does not include criteria for validating text.
You can validate a text entry, but you cannot check whether the entry is text or not.
Solution: Enter a formula that will check whether the data is text.


  1. Choose Data, Validation.
  2. Select the Settings tab.
  3. In the Allow box, select Custom.
  4. In the Formula box, enter =IsText(D4) (D4 is the first cell in the range).
  5. Click OK.