Forum Discussion
search several values
Hello,
Is it possible to add search for several values in Excel please ? (with CTRL+F window or simple method)
Thanks for everything, Good day !
2 Replies
https://www.ablebits.com/office-addins-blog/2020/10/14/excel-wildcard-find-replace-filter-formulas/
Not really, but you can use wildcards in the Find what box: ? stands for any single character, and * for any number of characters (including none).
For example, entering Employee* in the Find what box will find
Employee 1
Employee John
Employees
Employee benefit
etc., but not
Anne's Employee
And entering b?t in the Find what box will find
bat
bet
bit
bot
but
etc., but not
boot
