RIGHT

The RIGHT function returns the specified number of characters from the end of a text string. When used with a number, the function returns the result as text.

Syntax

RIGHT(text, num_chars)

Arguments

  • text: The text string that contains the characters to extract.
  • num_chars: The number of characters to extract from the end of the text.

Return value

Returns the specified number of characters from the right side of the text string.

Example

RIGHT("Region-East", 4)

Returns East.

Excel equivalent

RIGHT

Enterprise planning, Integrated with PowerTable and Intelligence, native to Microsoft Fabric. Co Engineered with Lumel.
BUILT ON