Pro lesson · 4 exercises · first one free
Pulling out the first and last word
About this lesson
Split a full name into its first and last word, and handle text that has no space.
Text and dates · 4 short exercises in a live spreadsheet: you type each formula yourself and answer questions that make you predict results or spot bugs. Every answer is checked instantly.
What you'll practise
- Taking the text before the first space
- Taking the text after the last space
- What FIND returns when there is no space
- Handling text that has no space
Functions you'll use
Try the first exercise free
Type the formula in a real spreadsheet and get instant feedback. Exercise 1 of 4, no account needed.
Pro lesson
Unlock the whole lesson
Pro unlocks every lesson, the case studies and unlimited weak-spot review. The fundamentals track stays free.