RIGHT Function (Functions in Excel)
Original Text | Number Of Characters Required | Right String | |
Alan Jones | 1 | s | =RIGHT(C4,D4) |
Alan Jones | 2 | es | =RIGHT(C5,D5) |
Alan Jones | 3 | nes | =RIGHT(C6,D6) |
Cardiff | 6 | ardiff | =RIGHT(C7,D7) |
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. |
Full Name | Second Name | |
Alan Jones | Jones | =RIGHT(C28,LEN(C28)-FIND(" ",C28)) |
Bob Smith | Smith | =RIGHT(C29,LEN(C29)-FIND(" ",C29)) |
Carol Williams | Williams | =RIGHT(C30,LEN(C30)-FIND(" ",C30)) |
0 comments:
Post a Comment