Monday, August 3, 2015

Excel Tutorial - lesson 5 - UPPER

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.

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)