Excel FunctionsLesson 104Free preview
RIGHT
This lesson is part of Excel · All levels
Summary
RIGHT is an Excel text function that takes a number of characters from the right side of a text. The syntax is RIGHT(text, [num_chars]); if num_chars are passed, one last character is taken. This function is often used to separate the end of a code or number.
Key points
- Syntax: RIGHT(text, [num_chars])
- Characters counted from the far right
- If the num_chars exceed the length of the text, the entire text is returned
- Combined with LEN and FIND to break down the combined data
Full lesson
Code examples and quizzes
Full lessons, code examples, and quizzes are available to subscribers. 5 questions.