Page 29 - TP-Play_V-2.0_Book-6
P. 29

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)
                                       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:
            Step 1  Type the given data in the Excel 2016 worksheet.
            Step 2   Type =CONCATENATE(B3,C3) function in the cell D3 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(B3) function in the cell E3 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(B3) function in the cell F3 to convert the first name into lowercase. After
                     typing the function, press the Enter key from the keyboard.










                                                    Using LOWER function

                                                                                Formulas and Functions       29
   24   25   26   27   28   29   30   31   32   33   34