Page 34 - CG_v2.1_flipBooks_class_6
P. 34
Text Functions
Function Purpose Example
CONCATENATE It joins together two or more Input: =CONCATENATE(“Digi”, “code”)
(text1, text2) different text strings. Output: Digicode
It returns the specified number Input: =LEFT(“Digi”,3)
LEFT(text, num_
chars) of characters from the left side Output: Dig
of the text string.
It returns the specified number Input: =RIGHT(“Digi”,3)
RIGHT(text, num_ of characters from the right
chars) Output: igi
side of the text string.
It returns the length of the Input: =LEN(“Digi”)
LEN(text)
text string. Output: 4
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.
32 Computer Genius (V2.1)-VI

