Page 33 - Computer Genius Class 06
P. 33

Functions                    Purpose                                Example

                                         t con erts the te t string into  Input: =UPPER(“Digi”)
                  pper te t
                                        uppercase.                        Output: DIGI

                                         t con erts the te t string into  Input: =LOWER(“Digi”)
                  o er te t
                                        lo ercase.                        Output: digi

                  et us use the te t  unctions in   cel. To use the te t  unctions   ollo  the gi en steps














                   1  Type the following data
                   in the   cel  or sheet.



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

                 When you press the Enter  ey  the first name and last name appear a ter concatenation.














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


                 When you press the Enter  ey  the first name appears in uppercase.













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

                 When you press the Enter  ey  the first name appears in lo ercase.




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