HOW TO DELETE ALTERNATE ROW
April 19, 2021
Find & Replace with Wildcards
April 27, 2021
Wildcards (*, ? or ~) can be used to filter a list based on a condition. We can incorporate combinations of wildcards to form a condition in order to filter a list.
Examples:
• Company names starting with A
Typing A* and pressing Enter or clicking on OK will give us all names starting with “A”
• Company names starting with C and ending with E
Since “*” represents any number of characters, we use that wildcard as C*E to get the desired outcome
• Three letter Company names starting with X, ending with Z
“?” represents one character so we use that wildcard as X?Z
Conditions to filter the list can be anything you want, just use the appropriate wildcard and you will get your custom filtered list.
Contributor: Raj Rajeshwar Sharma
Third-year B.Com (Hons) student at St. Xavier's College, Kolkata. I am pursuing CFA. I have been working at Leveraged Growth as a Finance intern for the past 3 months. I am a Finance enthusiast with a keen interest in learning different programming languages.
