Right

Syntax

Right(Text[, Num_chars])

Text. Source string, from which you get the characters.

Num_chars. The number of characters from the string end to be obtained. Optional parameter. The default value is 1.

NOTE. To determine the parameter, specify either the parameter value or the cell address where it is located.

It returns the specified number of characters from the end of a text string.

Formula	Result	Description
=Right("0123", 3)	123	The last three characters in the 0123 string.
=Right(B6)	*	The last character in the string from the B6 cell. The B6 cell contains the 12* value.