Wildcard in Excel INTRODUCTION The wildcard characters in excel is the most underrated feature of excel and most of the people don't know about it. It is a very good to know feature as it can save lot of time and effort required to do some research in excel. There are three wildcard characters in excel. 1. Asterisk (*) 2. Question Mark (?) 3. Tilde (~) These three wildcard character definitely has a different purpose from each other. We will learn about these characters in detail in this article. 1. Asterisk (*) The Asterisk represents any number of characters in the text string. For Example, when you type Br*, it could mean Break, Broke, Broken. So * after Br could mean to select only words which starts with Br and it doesn't matter what words or number of characters are there after Br. You can similarly start the search with Asterisk. For Example, *ing, it could mean Starting, Ending, Beginning. So * before ing could mean to select only words which ends with ing and it doesn't matter what words or number of characters are there before ing. 2. Question Mark (?) The Question marks are used for single character. For Example, ?ove could mean Dove or Move. So here question mark represent single character which are M or D. 3. Tilde (~) We have already saw two wild characters Asterisk (*) and Question Mark (?). The third wildcard character which is Tilde (~) is used to identify the wildcard character. We have not come across many situation where we need to use tilde (~) but it's a good to know feature in excel.
- Fall '19