right

Previous chapterNext chapter Show allShow all    Hide allHide all

The function left (string, num) returns the last (num) characters of a text string.

Syntax: =right(string,num)

Example Example

Cell A1 = abcdefgh

=right(A1,3) is fgh

=right(A1,5) is defgh