LEFT Function Dictionary

Function Dictionary Function Examples Function Categories

Text Number Of
Characters Required
Left String
Alan Jones 1 A  =LEFT(C4,D4)
Alan Jones 2 Al  =LEFT(C5,D5)
Alan Jones 3 Ala  =LEFT(C6,D6)
Cardiff 6 Cardif  =LEFT(C7,D7)
ABC123 4 ABC1  =LEFT(C8,D8)
What Does It Do ?            
This function displays a specified number of characters from the left hand side of a
piece of text.
No special formatting is needed.
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)


Popular posts from this blog

Tamilnadu SIXTH all books free download, Tamilnadu 6th all books free download

Tamilnadu FIRST STANDARD all books free download, Tamilnadu 1ST STANDARD all books free download