Page 44 - ModularV1.1 _c7_flipbook
P. 44
Functions Purpose Example
It returns the specified number Input: =LEFT(“Touch”,3)
LEFT(text, num_chars) of characters from the left side
Output: Tou
of the text string.
It returns the specified number Input: =RIGHT(“Touch”,3)
RIGHT(text, num_
of characters from the right side
chars) Output: uch
of the text string.
It returns the length of the text Input: =LEN(“Touch”)
LEN(text)
string. Output: 5
It converts the text string into Input: =UPPER(“Touch”)
UPPER(text)
uppercase. Output: TOUCH
It converts the text string into Input: =LOWER(”Touch”)
LOWER(text)
lowercase. Output: touch
Let us use the Text functions by performing the following steps:
Step 1 Type the following data in the MS Excel worksheet.
Step 2 Type =CONCATENATE(A3,B3) function in the cell C3 to concatenate the first name and
last name.
Step 3 Press the Enter key from the keyboard.
Using CONCATENATE function
When you press the Enter key, first name and last name appears after concatenation.
Step 4 Type =UPPER(A3) function in the cell D3 to convert the first name into uppercase. After
typing the function, press the Enter key from the keyboard.
Using UPPER function
The first name appears in uppercase.
Step 5 Type =LOWER(A3) function in the cell E3 to convert the first name into lowercase. After
typing the function, press the Enter key from the keyboard.
Using LOWER function
42 Modular (Ver. 1.1)-VII

