Ch 14: Format & Modify Text with Functions in Excel

About This Chapter

Learn how to format and modify text with functions in Excel through this group of video lessons. Use our step-by-step lessons to learn everything there is to know about Excel.

Format & Modify Text with Functions in Excel: Chapter Summary

Once you've learned how to insert data, format and groups cells, you'll probably want to learn more about using functions to format and modify your text. Learn to return characters from text values, remove spaces from text, convert text between upper and lower case and how to join text items.

Experienced Excel instructors present these skills in easy-to-follow steps through video and text modules. Each lesson offers a quick self-assessment quiz so that you may gauge your progress. You can view as many times as you like, or use the lesson transcript, if you prefer.

Topics include the following:

  • Making use of LEFT, RIGHT and MID Excel functions
  • Removing spaces with the TRIM function
  • Using LOWER and UPPER functions
  • Joining text items to make one with the CONCATENATE function

(Note: All demonstrations in this chapter will be using Microsoft Excel 2013. Certain features, tools, or displays may be different in other versions.)

Excel is a trademark of the Microsoft Corporation, which is not affiliated with

Chapter Practice Exam
Test your knowledge of this chapter with a 30 question practice chapter exam.
Not Taken
Practice Final Exam
Test your knowledge of the entire course with a 50 question practice final exam.
Not Taken

Earning College Credit

Did you know… We have over 160 college courses that prepare you to earn credit by exam that is accepted by over 1,500 colleges and universities. You can test out of the first two years of college and save thousands off your degree. Anyone can earn credit-by-exam regardless of age or education level.

To learn more, visit our Earning Credit Page

Transferring credit to the school of your choice

Not sure what college you want to attend yet? has thousands of articles about every imaginable degree, area of study and career path that can help you find the school that's right for you.