RIGHT Function or RIGHT Formula in Excel with example

RIGHT Function or RIGHT Formula in Excel with example

RIGHT

Function extracts desired number of characters from the right side or end of the given string in reverse order. Right function returns string as result.

Syntax

=RIGHT(text, [num_chars])

Parameters

  1. text: refers to string from you wish to extract number of characters. Its a mandatory parameter as string type.
  2. num_chars: it is an optional parameter and should be positive number. if supplied negative #VALUE! error would be returned. If removed then first character from right side will be returned.

Formula example

Output

Next >> Understand LEFT function in Excel with example

Leave a Reply

Your email address will not be published.