Data Validation, cell range needs full text search

Note that your screenshot is not from Excel, but from Excel Online.
It could change in later versions, but Excel 2016 does not.

Here is the sensation. :slightly_smiling_face:

1 Like