Returns a specified number of characters (including spaces) from the end of a text string.
Syntax
RIGHT (“Text”, NumberOfCharacters)
Note: The required separator (comma or semi-colon) automatically corresponds to your computer’s location settings.
Data Types of the Arguments
Text: String
Number of Characters: Integer
Data Type of the Result
String
Example
Return the final nine characters from the (right) end of a text string.
Expression
RIGHT (“The quick brown fox”, 9)
Result
brown fox
Relevant topics
Split String to Right [SPLITRIGHT]
Splits a string into parts at a given delimiter.
Returns the specified part and all parts to its right.
Syntax
SPLITRIGHT ...
Replace in String [REPLACE]
Replaces a given number of characters within a string with another string, starting from a specified position.
Syntax
REPLACE ...
Convert to String [STR]
Converts a non-unit numeric value or a True/False value into a string.
The resulting string shows two decimal places by default.
Syntax
...