Excel Formulas and Functions Part 6: Text Functions

Chris Dutton, Founder, Excel Maven

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
10 Videos (36m)
    • Introduction to Text Functions

      0:57
    • UPPER/LOWER/PROPER & TRIM

      3:32
    • The CONCATENATE Function (&)

      3:26
    • LEFT/MID/RIGHT & LEN

      3:31
    • TEXT/VALUE

      4:20
    • SEARCH/FIND

      5:04
    • Categorizing Data with IF(ISNUMBER(SEARCH))

      5:39
    • Combining RIGHT, LEN, and SEARCH

      5:44
    • BONUS: The SUBSTITUTE Function

      2:21
    • HOMEWORK: Text Functions

      0:59