ExcelHeroThe RIGHT function
Takes characters from the end of text.
In German Excel: RECHTS
How to write it
=RIGHT(text, [num_chars])- text
- The text.
- num_chars
- How many characters.
💡 RIGHT(A2,LEN(A2)-FIND(" ",A2)) gets everything after the first space.
Try it
Take the 3-letter colour from the end of the code in C2.
A
B
C
D
1
Full name
City
Code
Colour
2
maya lopez
berlin
TS-1042-BLU
3
LEO KING
paris
HD-0077-RED
4
sam o’neil
Rome
MG-3150-GRN
=RIGHT(text, how many).