Page 51 - modular4.0
P. 51
Chapter Profile
4 Calculate the Tax by
using the =(D6*7)/100
formula in cell D7.
5 Calculate the Total by using the =SUM(D6:D7)
function in cell D8.
Text Functions
Function Purpose Example
Input: =CONCATENATE(“Touch”,
It joins together two or more
CONCATENATE(text1, text2) “pad”)
different text strings.
Output: Touchpad
It returns the specified number Input: =LEFT(“Touch”,3)
LEFT(text, num_chars) of characters from the left side
of the text string. Output: Tou
It returns the specified number Input: =RIGHT(“Touch”,3)
RIGHT(text, num_chars) of characters from the right side
of the text string. Output: uch
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)
upper case. Output: TOUCH
It converts the text string into Input: =LOWER(”Touch”)
LOWER(text)
lower case. Output: touch
Let us use the Text functions by performing the following steps:
1 Type the given
data in the Excel 2019
worksheet.
2 Type =CONCATENATE(B3,C3) function in the cell D3 to
concatenate the first name and last name and press Enter key.
When you press the Enter key, first name and last name appears after concatenation.
Formulas and Functions 49

