Excel 365 for advanced users
ExpertExpert
14 questions, about 25 minutes
Split text with one formula, choose columns and rows, find a position with XMATCH and give intermediate results a name with LET.
What we'll do
- Splitting text with TEXTSPLIT
- Choosing columns and rows
- Finding a position with XMATCH
- Giving a name with LET
What you'll use
TEXTSPLITCHOOSECOLSXMATCHLETCHOOSEROWS
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
14questionsYou do it yourself