Excel FunctionsLesson 118Free preview
UPPER
This lesson is part of Excel · All levels
Summary
UPPER is an Excel text function that converts all the letters in the text into capital letters. The syntax is. Numbers, symbols, and spaces are unaffected, so this function is safe to use to unify codes or names.
Key points
- Syntax: UPPER(text) converts all letters into capital
- Numbers, symbols, and spaces are continuous without change
- Useful for unifying search codes or keys
- Mixed with SUBSTITUTE or TRIM for net result
Full lesson
Code examples and quizzes
Full lessons, code examples, and quizzes are available to subscribers. 5 questions.