Page 44 - ModularV1.1 _c7_flipbook
P. 44

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)
                                             uppercase.                          Output: TOUCH

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

                  Let us use the Text functions by performing the following steps:
                  Step 1  Type the following data in the MS Excel worksheet.
                  Step 2  Type =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 appears after concatenation.
                  Step 4  Type =UPPER(A3) function in the cell D3 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(A3) function in the cell E3 to convert the first name into lowercase. After
                          typing the function, press the Enter key from the keyboard.










                                                          Using LOWER function

                  42      Modular (Ver. 1.1)-VII
   39   40   41   42   43   44   45   46   47   48   49