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
|