On UrbanPro

View My Profile       Proud to be a Teacher       Write a Review  

Monday, May 19, 2014

RIGHT Function in MS- Excel

C
D
E
3
Original
Text
Number Of
Characters Required
Right
String
4
Alan Jones
1
s
 =RIGHT(C4,D4)
5
Alan Jones
2
es
 =RIGHT(C5,D5)
6
Alan Jones
3
nes
 =RIGHT(C6,D6)
7
Cardiff
6
ardiff
 =RIGHT(C7,D7)
8
ABC123
4
C123
 =RIGHT(C8,D8)

What Does It Do?
This function displays a specified number of characters from the right hand side of a piece of text.

Syntax
=RIGHT(OriginalText,NumberOfCharactersRequired)

Formatting
No special formatting is needed.

Example
The following table was used to extract the second name of a person from their full name.
The =FIND() function locates the position of the space between the first and second name.
The length of the second name is calculated by subtracting the position of the space from the overall length of the full name.
The =RIGHT() function can then extract the second name.

C
D

27
Full Name
Second Name

28
Alan Jones
Jones
 =RIGHT(C28,LEN(C28)-FIND(" ",C28))
29
Bob Smith
Smith
 =RIGHT(C29,LEN(C29)-FIND(" ",C29))
30
Carol Williams
Williams
 =RIGHT(C30,LEN(C30)-FIND(" ",C30))

No comments:

Post a Comment

Popular Posts