Page 57 - TP_Prime_v2.2_Class_6
P. 57
Function Purpose Example
LEFT(text, It returns the specified number Input: =LEFT(“Touch”,3)
num_chars) of characters from the left side Output: Tou
of the text string.
RIGHT(text, It returns the specified number Input: =RIGHT(“Touch”,3)
num_chars) of characters from the right side Output: uch FORMULAS AND FUNCTIONS IN EXCEL
of the text string.
It returns the length of the text Input: =LEN(“Touch”)
LEN(text)
string. Output: 5
UPPER(text) It converts the text string into Input: =UPPER(“Touch”)
uppercase. Output: TOUCH
It converts the text string into Input: =LOWER(”Touch”)
LOWER(text)
lowercase. Output: touch 55
Let us use the Text functions by performing the following steps:
Step 1: Type the following data in the Excel worksheet.
Step 2: Type the =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 appear after concatenation.

