View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default Search for Text in Excel

Data|Filter|Autofilter

And then custom filter: Begins with EV
(or equals EV*)

Maybe...

Duncan, UK wrote:

I am creating a list of part numbers of which some will be similar (different
variants of products) and I want to create a user search function eg a search
box that the users could enter the first few letters followed by a wild card
eg EV* and then the products starting with that prefix would be found.
I know you can use the Find function under Edit, but I was hoping for a more
user friendly tool.
Any ideas.
Regards
Duncan


--

Dave Peterson