| RIGHT | ||||||
| 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)) | ||||
Monday, August 3, 2015
Excel Tutorial - lesson 3 - RIGHT
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment