Page 26 - Trackpad_ipro 4.1_Class8
P. 26

Function                        Purpose                            Example

                                                  Converts  the  text  string  into  Input: =UPPER(“Track”)
                            UPPER(text)
                                                  uppercase                        Output: TRACK

                                                  Converts  the  text  string  into  Input: =LOWER(”Track”)
                           LOWER(text)
                                                  lowercase                        Output: track

                  To use the text functions in Excel, follow these steps:














                        1  Type the 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 and last name appear after concatenation.















                                                 3  Type =UPPER(A3) function to convert the First Name
                                                 into uppercase and 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.


                  The first name appears in lowercase.


                    24     iPro (Ver. 4.1)-VIII
   21   22   23   24   25   26   27   28   29   30   31