Text Functions — LEFT, RIGHT, MID, CONCAT, TEXTJOIN, and TRIM

In this lesson, we will learn text functions in Excel. We will understand how to extract, combine, and clean text values using LEFT, RIGHT, MID, CONCAT, TEXTJOIN, and TRIM through practical examples. ## Lesson objective In this lesson, we will learn text functions in Excel. In the previous lesson, we covered logical functions. We learned how to create condition-based statuses, segments, and decision columns using , , , and . Now we move to working with text data. In Excel, data is often not only numbers. Files may contain names, surnames, cities, emails, product codes, customer IDs, statuses, descriptions, and other text values.