"Contains" and "Starts With", and more, now in OpenOffice Calc 3.2

You could do it before with regular expressions, but now you can have more control in filtering with:

• Contains
• Does Not Contain
• Begins With
• Does Not Begin With
• Ends With
• Does Not End With

From the spec: "The "Standard Filter" dialog now shows 4 instead of 3 conditions, and has a scroll bar which allows to access up to 8 conditions in total. It now supports the filter conditions 'Contains', 'Does not contain', 'Begins with', 'Does not begin with', 'Ends with' and 'Does not end with'."

So you can look for Hansen and Hanson but not, say, Senngard or Pensonner, by using "Ends with" and an OR.

(Note that as always you have to be careful....you would also find Manson with this, so you might want to just look for = Hanson or = Hansen.)