Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 33 - 2632_CodeMind
P. 33

    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

| 28 29 30 31 32 33 34 35 36 37 38 |