SEARCH
Gives the position of text within text, ignoring capitals.
How it’s written
SEARCH(find, within)Example
| A | |
|---|---|
| 1 | Name |
| 2 | Amara Osei |
=SEARCH("o",A2)Result: 7
Finds the O in Osei, even though the search is lowercase.
Try it yourself
Open a live sheet with this example, and type the formula yourself. It takes a moment to load.
Worth knowing
Use FIND when capitals matter, and SEARCH when they don’t.
Practice it properly
Splitting at a marker gives you real tasks, with your formulas tested on data you haven’t seen.