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.
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.
