Page 34 - ThinkGPT_V2.1_C6_Flipbook
P. 34

Text Functions



                   Function              Purpose                           Example

                   CONCATENATE           It joins together two or more     Input: =CONCATENATE(“Digi”, “code”)
                   (text1, text2)        different text strings.           Output: Digicode

                                         It returns the specified number  Input: =LEFT(“Digi”,3)
                   LEFT(text, num_
                   chars)                of characters from the left side   Output: Dig
                                         of the text string.
                                         It returns the specified number  Input: =RIGHT(“Digi”,3)
                   RIGHT(text, num_      of characters from the right
                   chars)                                                  Output: igi
                                         side of the text string.
                                         It returns the length of the      Input: =LEN(“Digi”)
                   LEN(text)
                                         text string.                      Output: 4

                                         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.



                       32    Premium Edition-VI
   29   30   31   32   33   34   35   36   37   38   39