Wildcards: * and ?
Exercise 1 of 4
In D2, count the codes that start with TX.
About this lesson
In conditions, * stands for any text and ? for any one character. Use them to count codes that start or end a certain way.
In this lesson
- In
D2, count the codes that start with TX. - In
D2, count the codes that end with -BK. - In
D2, count the codes whose number starts with 1 (the 4th character is 1). - In
B2, check whether the code contains BL anywhere.
Use the arrow keys to move between cells; each cell is read out as you go. Type a formula and press Enter. The sheet is also available as a table below.
fx
Type in D2 and press Enter to check.