Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / October 2006

Tip: Looking for answers? Try searching our database.

APPROXIMATE SEARCH OF ANY ENTRY IN A COLUMN

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
arun_bhilai - 28 Oct 2006 06:02 GMT
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.
JMB - 28 Oct 2006 06:59 GMT
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.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.