Filter specific text in a string

[SLSchmidt]

I would like to create a filter that scans a specific column that gives me the results for FORD ,
The word FORD could be at the start-middle-end of a string
 
It would return examples of :  Ford of Iowa,  Iowa City Ford, or City Ford of Iowa
 
So only containing the 4 character word 'FORD'  
 
 
So this filter would return Bob Jones Ford, Heritage Ford, and also Affordable Ford of Hartford
but it would not return: Fordtown High,  Affordable Pest control, nor Hartford Insurance   (these results are what I get using 'Contains')
 
How would I go about stating this filter ?

[JosephSerpis · Accepted solution]

Hi @SLSchmidt I mocked up a workflow let me know what you think?

[SLSchmidt]

U Da Man,     Worked like a dream,,, Thanks

[shungui]

Hi,

I have this exact same issue. I tried the solution offered herein, but I keep getting this error:

Can someone please assist?

Thank you