About This Chapter
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 Study.com.
1. Using the RIGHT, LEFT and MID Functions in Excel
Have you ever needed to capture or extract just a piece of a data string in a cell? For instance, the cell data is RGT123456K9, but all you need is the middle six numbers? The RIGHT, LEFT and MID functions will help you extract just would you need.
2. Using the TRIM & CLEAN Functions to Fix Data in Excel
Have you ever received an Excel file with information imported from another database? Did you find extra spaces? Non-printable characters? This lesson explains how to use the TRIM function and its partner, CLEAN.
3. Using the UPPER and LOWER Functions in Excel
If you need to change the text in a worksheet to uppercase, lowercase, or just return it to proper case, there is a function that you can use to write a formula and Excel will do the work. This lesson will discuss the upper, lower, and proper functions in Excel.
4. How to Use the CONCATENATE Function in Excel
Ever want to combine two columns into one? This lesson will demonstrate how to use the Concatenate function in Excel. Using this function in a formula will allow you to merge multiple columns of data into one.
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? Study.com 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.
Other chapters within the Intro to Excel: Essential Training & Tutorials course
- Creating Worksheets & Workbooks in Excel
- Formatting Worksheets & Workbooks in Excel
- Customizing Options & Views in Excel
- Configure to Print & Save in Excel
- Format Cells & Ranges in Excel
- Insert Data in Cells and Ranges in Excel
- Filter and Sort a Table in Excel
- Order & Group Cells & Ranges in Excel
- Create a Table in Excel
- Modify a Table in Excel
- Use Cell Ranges & References for Formulas & Functions in Excel
- Summarize Data with Functions in Excel
- Functions with Conditional Logic in Excel
- Create a Chart in Excel