Exercises / Cleaning text · 12 of 13
Flag tickets that mention a refund
SEARCH(what, text) returns the position of a word, or #VALUE! when it is missing. Wrap it in ISNUMBER to get TRUE or FALSE. SEARCH ignores case; FIND does not.
Your taskIn C2, use SEARCH to look for the word refund in the message in B2, in any capitalisation: return "Refund" when it is there, and "" (empty) otherwise. It will be copied down to C8.
Pro
Unlock this exercise and every module after the basics.
Pro opens every exercise in every module, your review schedule, and the final test for the course certificate.
| Row | A | B | C |
|---|---|---|---|
| 1 | Ticket | Message | Flag |
| 2 | T-801 | Where is my parcel? | |
| 3 | T-802 | I would like a refund for the broken lamp | |
| 4 | T-803 | Refund requested, item arrived late | |
| 5 | T-804 | Can I change my delivery address? | |
| 6 | T-805 | Still waiting on my REFUND | |
| 7 | T-806 | Great service, thanks! | |
| 8 | T-807 | Is a refund possible after 30 days? |