The RIGHT and the LEFT Functions in Microsoft Excel 2010


In the following article, we will guide you on the usage and the syntax of the RIGHT and the LEFT functions present in Excel 2010 application.

Description

The RIGHT Function returns the last character or the rightmost characters of a particular string based upon the number of characters you specify whereas, the LEFT Function returns the first character or the leftmost characters of a particular string based upon the number of characters you specify.

Syntax

The syntax for the RIGHT and the LEFT Functions are: -

=RIGHT(text, num_of_chars)


=LEFT(text, num_of_chars)



Where, the ‘text’ is the text string that contains characters from which you wish to extract.

The 'num_of_chars' is the number of characters that you wish to extract from the text string.


NOTE: - the num_of_chars argument must be greater than or equal to zero. If the num_of_chars is greater than the length of the text, the RIGHT and the LEFT Functions return the whole text string. In case, if you omit the num_of_chars, it will be treated as 1.

Examples


RIGHT Function


Figure 1


Suppose, you wish to extract the last five characters from a particular string called “Itechtalk Forum”, then, the formula for the RIGHT Function should be written as

=RIGHT(“Itechtalk Forum”,5)

The above formula returns the last five characters (Forum) from the string “Itechtalk Forum”.

You can also use cell references as the first argument to the RIGHT Function. For example, the formula =RIGHT(C4,4) will extract the last 4 characters from the string present in cell C4.


LEFT Function


Figure 2


Suppose, you wish to extract the first nine characters from a particular string called “Itechtalk Forum”, then, the formula for the LEFT Function should be written as

=LEFT(“Itechtalk Forum”,9)

The above formula returns the first nine characters (Itechtalk) from the string “Itechtalk Forum”.

You can also use cell references as the first argument to the LEFT Function. For example, the formula =LEFT(C4,6) will extract the first 6 characters from the string present in cell C4.


So, this is how you can use the RIGHT and the LEFT functions to extract the rightmost and the leftmost characters from a particular string.


Read Other Applications