Use Of Wildcards in Excel

Hello Friends,

In this tutorial, I will give you examples of wildcards character in Excel. Wildcards are very useful in excel.

There are only 3 Excel wildcard characters (asterisk, question mark, and tilde) and a lot can be done using these.

1. Asterisk (*): It represents any number of characters. It means "*" character represents one or more than one character. Example "IN*" could mean  INDIA, INDONESIA, INOVA.

2. Question Mark (?): It represents only one character. Example  "IN?" could mean INX, IND, INT.

3.Tilde (~): It is used to find the wildcard character (Asterik, Question Mark) in text. Example Suppose you want to find the word followed by *, you have to write the tilde character before the asterisk (~*text).

Examples of  Asterisk:

Count the text from the data range that ends with "ard".

Count the text from the data range that starts with "mo".

Examples of  Question Mark:

Count the number of text from the data range that has only 3 characters and starts with "MO".

Count the number of text from the data range that has 3 characters long.

Examples of  Tilde:

Count the number of text that has "*" character.