SEARCH and FIND
AdvancedExpert
10 questions, about 18 minutes
Find the position of a character, so you can take pieces of varying length out of a text.
What we'll do
- Finding the position of a character
- Combining it with LEFT
- The difference between the two functions
What you'll use
SEARCHFINDLEFTTEXTAFTERMID
How it works
In an example you watch and don't need to fill anything in. You answer a question yourself. If it goes wrong, you get a tip, then a hint and finally the solution.
2examplesYou watch
10questionsYou do it yourself