Exceljet

Quick, clean, and to the point

Excel UPPER Function

Excel UPPER function
Summary 

The Excel UPPER function returns a upper-case version of a given text string. Numbers and punctuation are not affected.

Purpose 
Convert text to upper case
Return value 
Uppercase text.
Syntax 
=UPPER (text)
Arguments 
  • text - The text thatto convert to upper case.
Usage notes 
  • All letters in text are converted to upper case.
  • Numbers and punctuation characters are not affected.

Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.