Sort by middle word?

is it possible to sort or find the lines that have a particular word (in a specific column)?

for example, I have a column titled part#, I want to find all part # with the word "unit" in them. Unfortunately the word Unit is somewhere in the middle of the text

thanks!