Excel Tip #4: Wild Card Characters.
- This topic is empty.
-
Posts
-
Rishabh Surana
There are three wildcard characters in Excel: 1. * (asterisk) – It represents any number of characters. For example, Ex* could mean Excel, Excels, Example, Expert, etc.
2. ? (question mark) – It represents one single character. For example, B?tter could mean Better, Butter, Bitter, etc.
3. ~ (tilde) – It is used to identify a wildcard character (~, *, ?) in the text.
Applications:
1. You can use it in any formula (specially in criteria part) to return desired results.
Ex: =Sumif(criteria range, “A*”, sum range) to sum all the values beginning with A in criteria range.
2. You can use it in search box of filter menu.
Ex: Type “A?a*” to search for all words of any length beginning with “A” & 3rd alphabet also “A”. It will give results like Amazon, amaze, alarm etc.
3. You can use it in Find & Replace dialog box too.
4. Also it can be used in Conditional Formatting with formula.
Sent from my SM-A605G using
Actuarial Info mobile app
- You must be logged in to reply to this topic.