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.
   52   53   54   55   56   57   58   59   60   61   62