Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 37 - ClickGPT V4.0 C-5
P. 37

    Text Functions

                     Text functions are used to work on the characters entered as text.

                            Functions                             Purpose                                 Example

                                                                                                 Input: =CONCATENATE
                     Concatenate               It joins together two or more different text      (“Touch”, “pad”)
                     (text1, text2)            strings.
                                                                                                 Output: Touchpad

                                               It returns the specified number of characters     Input: =LEFT(“Touch”,3)
                     Left(text, num_chars)
                                               from the left side of the text string.            Output: Tou

                                               It returns the specified number of characters     Input: =RIGHT(“Touch”,3)
                     Right(text, num_chars)
                                               from the right side of the text string.           Output: uch

                                                                                                 Input: =LEN(“Touch”)
                     Len(text)                 It returns the length of the text string.
                                                                                                 Output: 5

                                                                                                 Input: =UPPER(“Touch”)
                     Upper(text)               It converts the text string into upper case.
                                                                                                 Output: TOUCH

                                                                                                 Input: =LOWER(”Touch”)
                     Lower(text)               It converts the text string into lowercase.
                                                                                                 Output: touch

                     Let’s use the Text functions by following these steps:

                                                                                           Type =CONCATENATE(A3,B3)
                           Type the given                                                  function  to concatenate the
                       1   data in the Excel                                               first name and last name and   2
                           worksheet.                                                      press Enter key.

                     When you press the Enter key, the first name and last name appear after the concatenation.

                     Logical Functions

                     Logical functions are used to test whether a condition is true or false.

                         Functions                              Purpose                                   Example
                                                                                                 Percentage = 80
                                        It checks whether the given condition is fulfilled or not
                     IF(condition,      and  returns  value1  if  the  condition evaluates to  true   Input: =IF(Percentage >=
                     value1, value2)                                                             50, “Passed”, “Failed”)
                                        and value2 if the condition evaluates to false.
                                                                                                 Output: Passed

                                                                                 Charts, Formulas & Functions in Excel  35

| 32 33 34 35 36 37 38 39 40 41 42 |