Explanation

Data validation rules are triggered when a user adds or changes a cell value.

If found, FIND will return a numeric position (i.e.

2, 4, 5, etc.)

Excel formula: Data validation allow numbers only

to represent the starting point of the text in the cell.

If the text is not found, FIND will return an error.

The result returned by the FIND function is then evaluated by the ISNUMBER function.

Excel formula: Data validation allow text only

For any numeric result returned by FIND, ISNUMBER will return TRUE and validation will succeed.

When the text is not found, FIND returns a #VALUE error.

Excel formula: Data validation must not contain

Excel FIND function

Excel ISNUMBER function