From the course: Cert Prep: Excel 2016 Microsoft Office Specialist (77-727)

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Format and modify text by using functions

Format and modify text by using functions

From the course: Cert Prep: Excel 2016 Microsoft Office Specialist (77-727)

Start my 1-month free trial

Format and modify text by using functions

“

- [Narrator] There are three very helpful functions that we can use to format and modify our text in our worksheets. In this video, we're going to talk about how to use the UPPER function to take the text in a cell and make it all upper case. We'll also demonstrate how to use the LOWER function which does just the opposite. It will take all of the text in a cell and make it lower case. The third function we will review is PROPER. PROPER takes the first letter of each word in a cell and capitalizes it. During the Excel 2016 MOSS Exam, you may be asked to use any of these functions, so we'll take time to review each one, and that'll help you be better prepared for the MOSS Exam. I have the 05_04 exercise file open, so let's go ahead and get started. First, let's look at upper case. We can see that our first names in our FIRST NAME column are all lower case. Let's use the UPPER function to change the text so all the first names are totally upper case. I'll click in D5. Type an equals…

Contents