String from Right [RIGHT]

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

  • Was this Helpful ?
  • YesNo
Relevant topics
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 ...