This article describes the formula syntax and usage of the RIGHT function in Microsoft Excel.
Description
RIGHT returns the last character or characters in a text string, based on the number of characters you specify.
Syntax
RIGHT(text,[num_chars])
The RIGHT function have the following arguments:
-
Text Required. The text string containing the characters you want to extract.
-
Num_chars Optional. Specifies the number of characters you want RIGHT to extract.
-
Num_chars must be greater than or equal to zero.
-
If num_chars is greater than the length of text, RIGHT returns all of text.
-
If num_chars is omitted, it is assumed to be 1.
-
Example
Copy the example data in the following table, and paste it in cell A1 of a new Excel worksheet. For formulas to show results, select them, press F2, and then press Enter. If you need to, you can adjust the column widths to see all the data.
|
Data |
Description |
|
|---|---|---|
|
Sale Price |
||
|
Stock Number |
||
|
Formula |
Description (Result) |
Result |
|
=RIGHT(A2,5) |
Last 5 characters of the first string (Price) |
Price |
|
=RIGHT(A3) |
Last character of the second string (r) |
r |
Important: The RIGHTB function is deprecated. RIGHT now supports Unicode surrogates via the Compatibility Version, Version 2.
