Suppose you are asked to figure out the number of cells in a range contain a particular word, example "hi" (without double quotes).
The example is shown in the image below.
The asterik (*) is used to find matches. It substitutes any other characters.
The example is shown in the image below.
The asterik (*) is used to find matches. It substitutes any other characters.
Download the workbook
- Hi* would find anything that starts with "Hi"
- *Hi would find anything that ends with "Hi"
- *Hi* would find anything that contains "Hi"
Love this!
ReplyDeleteSo good..
ReplyDeleteThank you.....