RIGHT

Get rightmost characters from a text in Excel
Rightmost characters from a text value

Rational

Find text from the right side.

Description

The Excel RIGHT function extract rightmost characters based on the specified number. For example, =RIGHT(“String”,4) returns “ring”.

Syntax

=RIGHT(text,[num_chars])

Parameters

text – The text that contains the characters
num_chars [Optional] – Number of characters to extract.

Return Value

Specific number of right-side characters of text.

Key Notes

  • Use the LEFT and MID function to extract a specific number of characters based on given leftmost and starting positions respectively.
  • If number_chars is “zero” (0) or blank, RIGHT returns “” (empty text),num_chars must be greater than or equal to zero otherwise, the Excel will return #VALUE! error.
  • Excel store the return value of the RIGHT function in text format hence does not accept the number formatting. Like if the return value is 333 the user cannot change the cell formatting to $333.
  • The default num_charsargument is 1.
To find number at right side with space in Excel we will use RIGHT function like here value “123 45”  we put formula =RIGHT(“123 45”,4) it return 3 45 space is also count.

Keep Reading Similar Functions:

Returns characters from the left side of a text string in Excel

LEFT

The LEFT function display number of characters specified in the argument of text starting from the left. I.e., LEFT(“Excel LEFT function”,5) returns “Excel”.

Read More »
Repeat same text in Excel

REPT

The Excel REPT function repeat a text for a specified number of times. For example, =REPT(“M”,3) returns “MMM”.

Read More »
Returns characters of a text string from the middle in Excel

MID

The MID function extracts a specified number of characters from the middle of a given text string. For example, =MID(“number”,1,3) returns “num”.

Read More »