You are here KNOWLEDGE Excel Tips Excel Text, Editing and Format Validating Text Entries

Query, Share and Manage Excel workbooks on LAN, Internet

Validating Text Entries

To validate text entries:

1. Select the range of cells.
2. From the Data menu, select Validation.
3. Select the Settings tab.
4. From the Allow dropdown list, select Custom.
5. In the Formula box, enter the following formula:
=IsText (A1)
where A1 is the first cell in the range.
6. Click OK.