You could do that w/the autofilter (Data/Filter/Autofilter). Click on the
arrow that appears in the name column, select custom, then contains, and
enter the name or partial name in the text box on the right side of the form.
> I have a column of names and a corrosponding column containing their contact
> numbers. I want to enter a paet of that name and i want to have all the names
> containing that part. but i cant find how to do this. please help.
> thanks in advance.