Quote:
Originally Posted by Reyaaz
In the attached example, the user types HR into the search box and a number of rows are pulled up which include HR.
A17 is fine as a search result, as it includes HR as a single word.
C15 and B16 are not, as they only include the word through, and not HR.
|
Instead "HR" search for "HR " (as leftmost characters in cell), " HR ", or " HR" (as rightmost characters in cell)
Edit: I.e. instead of single check, you have to check all 3 possibilities - in case any of them does pass, the record is displayed!