Page 33 - Digicode_AI_class_6
P. 33

Functions             Purpose                           Example

                                   It converts the text string into  Input: =UPPER(“Digi”)
             Upper(text)
                                   uppercase.                        Output: DIGI

                                   It converts the text string into  Input: =LOWER(“Digi”)
             Lower(text)
                                   lowercase.                        Output: digi


            Let us use the text functions in Excel. To use the text functions, follow the given steps:













               1  Type the following data
              in the Excel worksheet.



                                             2  Type =CONCATENATE(A3,B3) function to concatenate the
                                             First Name and Last Name and press the Enter key.


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













                                              3  Type =UPPER(A3) function to convert the First
                                              Name into uppercase and press the Enter key.


            When you press the Enter key, the first name appears in uppercase.













                                                    4  Type =LOWER(A3) function  to  convert  the
                                                   first name into lowercase and press the Enter key.


            When you press the Enter key, the first name appears in lowercase.



                                                                         Formulas and Functions in Excel  31
   28   29   30   31   32   33   34   35   36   37   38