Page 27 - iprime_V2.2_class8
P. 27

Functions                        Purpose                           Example

                                                 Returns the length of the text   Input: =LEN(“Touch”)
                            LEN(text)
                                                 string                           Output: 5

                                                 Converts  the  text  string  into   Input: =UPPER(“Touch”)
                          UPPER(text)
                                                 uppercase                        Output: TOUCH

                                                 Converts  the  text  string  into   Input: =LOWER(”Touch”)
                          LOWER(text)
                                                 lowercase                        Output: touch


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

                 Step 1  Type the following data in the Excel worksheet.
                 Step 2  Type =CONCATENATE(A3,B3) function in cell C3 to concatenate the first name and last

                         name.

                 Step 3  Press the Enter key.
























                                                     Using CONCATENATE Function

                        When you press the Enter key, the first and last name appear after concatenation.
                 Step 4  Type =UPPER(A3) function in cell D3 to convert the first name into uppercase. Press the
                        Enter key.














                                                         Using UPPER Function
                        The first name appears in uppercase.




                                                                             Spreadsheet—Functions and Charts      25
   22   23   24   25   26   27   28   29   30   31   32