Excel Tricks : Excel wildcards on your finger tips | * (asterisk) | ? (question mark) | ~ (tilde)
******************************************************
In this video, you will learnt about 3 Excel wildcard characters (asterisk, question mark, and tilde) and a lot can be done using these.
(asterisk) – It represents any number of characters. For example, Ex* could mean Excel, Excels, Example, Expert, etc.
? (question mark) – It represents one single character. For example, Tr?mp could mean Trump or Tramp.
~ (tilde) – It is used to identify a wildcard character (~, , ?) in the text. For example, let’s say you want to find the exact phrase Excel in a list. If you use Excel* as the search string, it would give you any word that has Excel at the beginning followed by any number of characters (such as Excel, Excels, Excellent). To specifically look for excel*, we need to use ~. So our search string would be excel~*. Here, the presence of ~ ensures that excel reads the following character as is, and not as a wildcard.
******************************************************
THANKS FOR WATCHING
ＬＩＫＥ | ＣＯＭＭＥＮＴ | ＳＨＡＲＥ | ＳＵＢＳＣＲＩＢＥ
------------------------------------------------------------------------------------