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 ?
Solved! Go to Solution.
U Da Man, Worked like a dream,,, Thanks
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