As well as using wildcards in Excel's Find And Replace dialog box, you can use them in arguments for various functions, such as XLOOKUP to generate a partial match lookup, COUNTIFS to count the ...

Fortunately, Excel’s Find and Replace function makes it easy to hunt down and correct mistakes or inconsistencies: Press Ctrl+F to open the Find and Replace dialog box ...