Text formulas, some of which you will need to use for the first 
Excel decryption of encrypted text (four letter words only) assignment.

    CONCATENATE
    LEFT
    RIGHT
    MID
    FIND
    LEN
    CODE
    CHAR

    In Excel, there are many uses the SUM and the AVERAGE functions.
    requires you to use a couple of the arithmetic operators in Excel.

    + for addition, - for subtraction, * for multiplication

    =B2*C2   multiplities the number in cell B2 by the cell C2 number.

    =LEN(A2)  tells the length of the string in cell A2.

    =LEN("GHOSTBUSTERS")   would give 12  =LEN("PANTHERS") would give 8

                                         ------------
    Suppose cell G5 contains the phrase "UNI Panthers"
                                         ------------
      LEN(G5)  would give 12

      FIND(" ", G5) would give 4 since the space is located at position 4.
      FIND("P", G5) would give 5
      FIND("h", G5) would give 9

      LEFT(G5, FIND(" ",G5) - 1) would give    UNI
                                               ---
      LEFT(G5, 3) would give    UNI
                                ---

      LEFT(G5, 1) would give    U
                                -

      RIGHT(G5, 4) would give   hers
                                ----

      RIGHT(G5, LEN(G5) - 4) would give Panthers
                                        --------

      CONCATENATE("** ", RIGHT(G5, 8), ", ", LEFT(G5, 3), "!! **")

            would give    ** Panthers, UNI!! **
                          ---------------------
      CONCATENATE(RIGHT("Panthers", 7), LEFT("Panthers", 1), "ay")

             would give          anthersPay
                                 ----------  which is Pig Latin...

      =FIND("bus", "Ghostbusters") would give 6
                    123456789012                since bus starts at the
                                                6th character....

      =FIND("t", "Ghostbusters") would give 5, as shown...
                  12345

      =FIND("Z", "Panthers") would display #VALUE!
                             since there is no Z in Panthers.


      =RIGHT("Panthers", Len("Panthers") - 1) would give anthers
                                                         -------

              which is everything except for the first character,
              and which translates into asking for the RIGHTmost 7
              characters of Panthers.

      =RIGHT("Panthers", 7)     gives    anthers
                                         -------

      Hopefully, this Excel review and further examples of the Text
          functions available from Insert menu, Function command or the
          f(x) toolbar button shortcut, has been helpful to you.

      Have a great weekend.

      Mark