I have a list in a SharePoint Online site, which contains a multi-line rich text field. The list item I'm interested in contains a HTML table, the first column of which consists of strings like
When I search for
AB47* in the Find an item search box at the top of the list, my list item appears in the results, as expected. The same is true if I search for
AB4702, but not for
AB4704. The list item doesn't appear in these last two searches.
The strings I'm searching for appear only in the field I mentioned, and checking the HTML confirms there aren't any invisible characters in the table that would cause the search not to match.
Why is it that the search matches one part of the field but not another?