Page 26 - Trackpad_ipro 4.1_Class8
P. 26
Function Purpose Example
Converts the text string into Input: =UPPER(“Track”)
UPPER(text)
uppercase Output: TRACK
Converts the text string into Input: =LOWER(”Track”)
LOWER(text)
lowercase Output: track
To use the text functions in Excel, follow these steps:
1 Type the 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 and last name appear after concatenation.
3 Type =UPPER(A3) function to convert the First Name
into uppercase and 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.
The first name appears in lowercase.
24 iPro (Ver. 4.1)-VIII

