RIGHT

TextExcel 2007

The last N characters of a string.

Syntax

RIGHT(text, [num_chars])

Arguments

text: The string.
num_charsoptional: How many characters from the right. Default 1.

Examples

=RIGHT("INV-000841", 6)

→ 000841

Related functions

LEFT MID TEXTAFTER

More Text functions

ARRAYTOTEXT ASC BAHTTEXT CHAR CLEAN CODE CONCAT CONCATENATE DBCS DOLLAR EXACT FIND

← All 510 functions

Syntax follows Microsoft’s documentation. Examples are written to be pasted into a cell and checked. Argument separators may be ; in your locale. The AI explainer runs on a free community model — verify anything important.