# RIGHT

## 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.

### 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”.

### REPT

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

### 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”.