Page 82 - 2622_Delhi Police Public School_C-6

Text Functions

Text functions are used to work on the characters entered as text.

Functions Purpose Example

Input: =CONCATENATE
CONCATENATE It joins together two or more different text (“Touch”, “pad”)
(text1, text2) strings.
Output: Touchpad

It returns the specified number of characters Input: =LEFT(“Touch”,3)
LEFT(text, num_chars)
from the left side of the text string. Output: Tou

RIGHT(text, num_ It returns the specified number of characters Input: =RIGHT(“Touch”,3)
chars) from the right side of the text string. Output: uch

Input: =LEN(“Touch”)
LEN(text) It returns the length of the text string.
Output: 5

Input: =UPPER(“Touch”)
UPPER(text) It converts the text string into upper case.
Output: TOUCH

Input: =LOWER(”Touch”)
LOWER(text) It converts the text string into lowercase.
Output: touch

Let’s use the Text functions by following these steps:

Type =CONCATENATE(A3,B3)
Type the given function to concatenate the
1 data in the Excel first name and last name and 2
worksheet. press Enter key.

When you press the Enter key, the first name and last name appear after the concatenation.

Logical Functions

Logical functions are used to test whether a condition is true or false.

Functions Purpose Example
Percentage = 80
It checks whether the given condition is fulfilled or not
IF(condition, and returns value1 if the condition evaluates to true Input: =IF(Percentage >=
value1, value2) 50, “Passed”, “Failed”)
and value2 if the condition evaluates to false.
Output: Passed

80 Premium Edition-VI