When you enroll through our links, we may earn a small commission—at no extra cost to you. This helps keep our platform free and inspires us to add more value.
Excel Formulas and Functions Part 6: Text Functions
Unlock creativity with Skillshare! Learn acrylic painting, AI writing, graphic design, and photography.
Free
This Course Includes
skillshare
0 (0 reviews )
35 minutes 
english
Online - Self Paced
course
SkillShare
About Excel Formulas and Functions Part 6: Text Functions
Introduction to Text Functions
UPPER/LOWER/PROPER & TRIM
The CONCATENATE Function (&)
LEFT/MID/RIGHT & LEN
TEXT/VALUE
SEARCH/FIND
Categorizing Data with IF(ISNUMBER(SEARCH))
Combining RIGHT, LEN, and SEARCH
BONUS: The SUBSTITUTE Function
HOMEWORK: Text Functions
What You Will Learn?
- This course is part 6 of a 9-part series on Excel Formulas & Functions: from basic to advanced..
- Text functions are remarkably versatile tools for manipulating and analyzing text fields in Excel. In this section we’ll review basic UPPER, LOWER, PROPER and TRIM functions, practice joining strings together with CONCATENATE, and combine text parsing functions like LEFT, MID, and RIGHT with tools like SEARCH, FIND and SUBSTITUTE to create incredibly powerful and dynamic formulas for text analysis..
- About the Excel Formulas & Functions Series:.
- In this series, you will develop tools to transform Excel from a basic spreadsheet program into a dynamic and powerful analytics tool. Courses cover 75+ formulas, and feature hands-on, contextual demos and practice exercises designed to help you not only memorize formula syntax, but to think like Excel..
- You'll learn how to write complex, powerful functions from scratch, allowing you to:.
- If you're looking for the ONE series covering all of the advanced formulas and functions that you need to become an absolute Excel rock star, you've found it!.