Wildcards
In this last exercise we will practice using wildcards to efficiently plough through long Product Name values!
You can complete this exercise on DataCamp using in-browser Excel, or locally if you have Excel installed.
Our criteria for this exercise: Order Item IDs related to "Book" but not to "Bookcase" in Product ID or Product IDs beginning with "TEC-PH".
To help and inspire you, here are some popular wildcard commands:
This exercise is part of the course
Advanced Excel Functions
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
Start Exercise