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