BeginnerText Functions
Pull a state code out of a territory with RIGHT
Take the trailing two-letter state abbreviation off the end of a territory code.
RIGHT
4 min10 points
RIGHT
Returns a set number of characters from the end of a text value.
Syntax
RIGHT(text, [num_chars])
Text Functions.
Practise RIGHT1 interactive exercise, free, no account needed
A worked example
=RIGHT(A2,4)
Returns Bell
Takes the last four characters of Marcus Bell — which only works because that surname happens to be four letters long.
Where it goes wrong
Like LEFT, a fixed count only works when every value is the same shape. Pair it with LEN and FIND for variable-length text.
What the exercises catch
Each of these is a wrong turn the practice exercises recognise and name. They are the misconceptions, not the answers.
- LEFT counts from the start of the text, so you get the first two letters of the region instead of the state. The state sits at the other end.Pull a state code out of a territory with RIGHT
- Typing the answer works for this one row and breaks on the next four. Write something you can fill down the column.Pull a state code out of a territory with RIGHT
Practise RIGHT
Knowing what a function does and being able to write it from memory are different skills. These close the gap.
All RIGHT practice exercises →