Page 33 - Computer Genius Class 06
P. 33
Functions Purpose Example
t con erts the te t string into Input: =UPPER(“Digi”)
pper te t
uppercase. Output: DIGI
t con erts the te t string into Input: =LOWER(“Digi”)
o er te t
lo ercase. Output: digi
et us use the te t unctions in cel. To use the te t unctions ollo the gi en steps
1 Type the following data
in the cel or sheet.
2 Type =CONCATENATE(A3,B3) function to concatenate the
First Name and Last Name and press the Enter ey.
When you press the Enter ey the first name and last name appear a ter concatenation.
3 Type =UPPER(A3) function to convert the First
Name into uppercase and press the Enter ey.
When you press the Enter ey the first name appears in uppercase.
4 Type =LOWER(A3) function to convert the
first name into lowercase and press the Enter ey.
When you press the Enter ey the first name appears in lo ercase.
Formulas and Functions in Excel 31

