FIND
Gives the position of text within text, matching capitals exactly.
How it’s written
FIND(find, within)Example
| A | |
|---|---|
| 1 | Name |
| 2 | Amara Osei |
=FIND(" ",A2)Result: 6
The space is the 6th character.
Try it yourself
Open a live sheet with this example, and type the formula yourself. It takes a moment to load.
Worth knowing
Use it with LEFT to split text of any length.
Practice it properly
Splitting at a marker gives you real tasks, with your formulas tested on data you haven’t seen.