RIGHT()
Returns a specified number of characters from the end of a text string.
RIGHT(text, [num_chars])RIGHT mirrors LEFT, pulling characters from the end of a string instead of the start. Omitting num_chars returns just the last character.
Combine with LEN when the piece you need is a fixed distance from the end but the total length varies, e.g. RIGHT(text, LEN(text)-4).
Arguments
- text
- The text to extract characters from.
- num_charsoptional
- How many characters to return, counting from the right. Defaults to 1.
Examples
=RIGHT("SKU-1049-BLK", 3)→BLK
Grabs the last 3 characters.