In order to do this you must add the same formula as a criteria to the search. So in my example I added formula(text)

{memo}

contains

[space]

as a criteria. Now I am able to add the formula(text) to the available filter and type things in to filter down the results. Note the space allows all results to come through initially and then be filtered.