Use the UPPER function to return data from a reference with all letters converted to upper case. Similarly, use the LOWER function to return data with all letters converted to lower case. Use the PROPER function to return data with all characters that begin a word capitalized and all others in lower case.
- [Voiceover] Excel has a function called PROPER.…That's the name of the worksheet we're…looking at right now, and two related functions…called UPPER and LOWER.…I recall a story a few years ago,…a summer intern who was asked to take…a bunch of names like we see here in column A…and retype them so they look like this.…In other words, capitalize only the first…letters of each word.…If only someone had known there's…a function in Excel for this.…I want this data to look like that.…Here of course, just capitalize the C and the R.…First letter of each name.…
If there's a hyphenated name like this,…I want the J capitalized, for example, in Jones.…And if there's a name like O'Brien,…like what we see here, I want the B…to be capitalized as well.…The function is called PROPER.…There it is.…Double click to copy this down the column.…The B in O'Brien is capitalized.…As we look down the list here,…the J in Morgan-Jones is capitalized.…Notice that the first D in Macdonald is not capitalized.…One of these days, maybe that will happen,…
Author
Dennis Taylor
Released
5/26/2016- Understanding how the hierarchy of operators affects formula results
- Knowing when to use absolute vs. relative references
- Using Formula Builder for unfamiliar functions
- Displaying a worksheet's formulas and highlighting formula cells
- Converting formulas to values
- Creating 3D formulas to gather data from multiple sheets
- Creating and expanding nested IF functions; using AND, OR, and NOT with IF
- Looking up information with VLOOKUP, HLOOKUP, MATCH, and INDEX
- Analyzing data with the statistical functions: MEDIAN, MODE, etc.
- Using the power functions: COUNTIF, SUMIF, COUNTIFS, AVERAGEIFS, and more
- Calculating financial data such as payments
- Performing basic math
- Calculating dates and times
- Editing text with functions
- Using array formulas and functions
- Referencing data in other cells and files
- Extracting information from Excel worksheets
Skill Level Intermediate
Duration
Views
-
Introduction
-
Welcome46s
-
Exercise files25s
-
-
1. Formula and Function Tools
-
2. Formula and Function Tips and Shortcuts
-
3. IF and Related Functions
-
4. Lookup and Reference Functions
-
Use MATCH and INDEX together4m 40s
-
5. Statistical Functions
-
6. Power Functions
-
7. Selected Financial Functions
-
8. Math Functions
-
9. Date and Time Functions
-
10. Text Functions
-
11. Array Formulas and Functions
-
12. Reference Functions
-
13. Information Functions
-
Conclusion
-
Next steps25s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Adjust case within cells using the PROPER, UPPER, and LOWER