the column A must have column heading in A1
click the arrow in column A heading
left hand side window choose "equal to"
in the right hand side window type
do you get what you want.
you can copy the filtered data anywhere
to remove filter click again data filter autofitler
* is the sign of wild card
the two * on both sides indicates any other characters or numbers before and after.
wildcards can be used only for some functins in excel