FIND and SEARCH practice exercises
Find where a character sits in a text, then use that position with LEFT, MID and LEN to cut text that has no fixed length, like names and email addresses.
- 1Find the @ in an email with FINDIn B2, use FIND to get the position of the @ in the email address in A2.
- 2Take the name before the @PremiumIn B2, get the part of the email in A2 before the @. Use LEFT, with FIND to work out how many characters to take.
- 3Take the domain after the @PremiumIn B2, get the domain, the part of the email in A2 after the @. Use MID to start one character after the @, and LEN for the number of characters.
- 4Check if a text contains a wordPremiumIn B2, show TRUE if the product name in A2 contains "pro" in any case. Use SEARCH inside ISNUMBER.
- 5Count the words in a cellPremiumIn B2, count the words in A2. There is one more word than there are spaces, and LEN(A2) minus the length without spaces, LEN(SUBSTITUTE(A2," ","")), is the number of spaces.