Page 33 - Digicode_AI_class_6
P. 33
Functions Purpose Example
It converts the text string into Input: =UPPER(“Digi”)
Upper(text)
uppercase. Output: DIGI
It converts the text string into Input: =LOWER(“Digi”)
Lower(text)
lowercase. Output: digi
Let us use the text functions in Excel. To use the text functions, follow the given steps:
1 Type the following data
in the Excel worksheet.
2 Type =CONCATENATE(A3,B3) function to concatenate the
First Name and Last Name and press the Enter key.
When you press the Enter key, the first name and last name appear after concatenation.
3 Type =UPPER(A3) function to convert the First
Name into uppercase and press the Enter key.
When you press the Enter key, the first name appears in uppercase.
4 Type =LOWER(A3) function to convert the
first name into lowercase and press the Enter key.
When you press the Enter key, the first name appears in lowercase.
Formulas and Functions in Excel 31

