Excel Function
RIGHT Function in Excel
Learn how to use the RIGHT function in Excel, understand the syntax and common use cases, and let ExcelGPT adapt the formula to your real workbook structure.
Syntax
RIGHT(text, [num_chars])Arguments
What each part of the formula does.
textRequiredThe text string to extract from.
num_charsOptionalOptional number of characters to return from the end, defaulting to 1.
Examples
Extract a two-letter country code
=RIGHT(A2, 2)Returns the last two characters of the text in A2.
Get the last digit
=RIGHT(B2)Returns the final character because num_chars is omitted.
Common mistakes
Check the argument order, data types, and references used in RIGHT.
Review whether ranges, blank cells, error values, or dynamic results are affecting the formula.
Validate the formula on a few sample rows before scaling it across the workbook.
Related functions
LEFT
Learn how to use the LEFT function in Excel, understand the syntax and common use cases, and let ExcelGPT adapt the formula to your real workbook structure.
CONCAT
Learn how to use the CONCAT function in Excel, understand the syntax and common use cases, and let ExcelGPT adapt the formula to your real workbook structure.
TEXTJOIN
Learn how to use the TEXTJOIN function in Excel, understand the syntax and common use cases, and let ExcelGPT adapt the formula to your real workbook structure.
Need a variant of this formula?
Describe your workbook structure and ExcelGPT can generate a version tailored to your real columns, ranges, and edge cases.