Pro lesson · 5 exercises · first one free
More text tools: RIGHT, SEARCH, VALUE and UPPER
About this lesson
Take text from the end, find a character, turn text into numbers and change the case.
Text and dates · 5 short exercises in a live spreadsheet: you type each formula yourself. Every answer is checked instantly.
What you'll practise
- Taking characters from the end of a text
- Turning extracted text into a real number
- Finding the position of a character
- Taking the part of an email before the at sign
- Changing text to upper case
Functions you'll use
Try the first exercise free
Type the formula in a real spreadsheet and get instant feedback. Exercise 1 of 5, 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.