Hi @JonKemp - I completely missed this question - my apologies.
The simplest way to find blank cells is to just type a space in the search box above the grid and hit enter. All rows that contain one or more empty property cells will be returned. To narrow down to a specific field, type the space, hit the magnifying glass and choose from the list.
You’re right - it does behave differently in advanced search. Like and Equal To will deliver different results, and @tim.janes has the right suggestion here.
- a ‘Like’ search for * * (star space star) will return blanks (where there is no data in the cell)
- an '‘Equal To’ search for * * (star space star) will return all data containing a space, like NOTTING HILL or MILTON KEYNES. It will not return blanks.