Page 27 - iprime_V2.2_class8
P. 27
Functions Purpose Example
Returns the length of the text Input: =LEN(“Touch”)
LEN(text)
string Output: 5
Converts the text string into Input: =UPPER(“Touch”)
UPPER(text)
uppercase Output: TOUCH
Converts the text string into Input: =LOWER(”Touch”)
LOWER(text)
lowercase Output: touch
To use the text functions in Excel, follow these steps:
Step 1 Type the following data in the Excel worksheet.
Step 2 Type =CONCATENATE(A3,B3) function in cell C3 to concatenate the first name and last
name.
Step 3 Press the Enter key.
Using CONCATENATE Function
When you press the Enter key, the first and last name appear after concatenation.
Step 4 Type =UPPER(A3) function in cell D3 to convert the first name into uppercase. Press the
Enter key.
Using UPPER Function
The first name appears in uppercase.
Spreadsheet—Functions and Charts 25

