| UPPER | ||||
| Lower Case Text | Upper Case | |||
| alan jones | ALAN JONES | =UPPER(C4) | ||
| bob smith | BOB SMITH | =UPPER(C5) | ||
| carol williams | CAROL WILLIAMS | =UPPER(C6) | ||
| cardiff | CARDIFF | =UPPER(C7) | ||
| abc123 | ABC123 | =UPPER(C8) | ||
| What Does It Do ? | ||||
| This function converts all characters in a piece of text to upper case. | ||||
| Syntax | ||||
| =UPPER(TextToConvert) | ||||
| Formatting | ||||
| No special formatting is needed. | ||||
| Example | ||||
| See the example for FREQUENCY. | ||||
Tutorials 4 All of You
Monday, August 3, 2015
Excel Tutorial - lesson 5 - UPPER
Excel Tutorial - lesson 4 - LOWER
| LOWER | ||||
| Upper Case Text | Lower Case | |||
| ALAN JONES | alan jones | =LOWER(C4) | ||
| BOB SMITH | bob smith | =LOWER(C5) | ||
| CAROL WILLIAMS | carol williams | =LOWER(C6) | ||
| CARDIFF | cardiff | =LOWER(C7) | ||
| ABC123 | abc123 | =LOWER(C8) | ||
| What Does It Do ? | ||||
| This function converts all characters in a piece of text to lower case. | ||||
| Syntax | ||||
| =LOWER(TextToConvert) | ||||
| Formatting | ||||
| No special formatting is needed. | ||||
Excel Tutorial - lesson 3 - RIGHT
| 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)) | ||||
Excel tutorial - lesson 2 - LEFT
| LEFT | ||||||
| Text | Number Of Characters Required |
Left String | ||||
| Alan Jones | 1 | A | ||||
| Alan Jones | 2 | Al | ||||
| Alan Jones | 3 | Ala | ||||
| Cardiff | 6 | Cardif | ||||
| ABC123 | 4 | ABC1 | ||||
| What Does It Do ? | ||||||
| This function displays a specified number of characters from the left hand side of a | ||||||
| piece of text. | ||||||
| Syntax | ||||||
| =LEFT(OriginalText,NumberOfCharactersRequired) | ||||||
| Formatting | ||||||
| No special formatting is needed. | ||||||
| Example | ||||||
| The following table was used to extract the first name of a person from their full name. | ||||||
| The =FIND() function was used to locate position of the space between the first and second name. | ||||||
| The length of the first name is therefore the position of the space minus one character. | ||||||
| The =LEFT() function can now extract the first name based on the position of the space. | ||||||
| Full Name | First Name | |||||
| Alan Jones | Alan | =LEFT(C27,FIND(" ",C27)-1) | ||||
| Bob Smith | Bob | =LEFT(C28,FIND(" ",C28)-1) | ||||
| Carol Williams | Carol | =LEFT(C29,FIND(" ",C29)-1) | ||||
Subscribe to:
Posts (Atom)