UPPER Function in Excel: Convert Text to Capitals

⏱ 1 min readUpdated 28 September 2026

TextLevel: BeginnerAvailable in: Excel 2007+

In this article
  1. Syntax
  2. Examples
  3. Example 1
  4. Example 2
  5. Related functions

UPPER makes text all capitals; LOWER makes it all small letters. Useful for codes, PAN and GSTIN that must be uppercase.

Syntax

=UPPER(text)
Argument What it means
text Text to convert.

Examples

Example 1

=UPPER(TRIM(A2))

Clean PAN: “ abcde1234f ” → ABCDE1234F.

Example 2

=LOWER(A2)

Email addresses in lowercase before de-duplicating.

LOWER · PROPER · EXACT

📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.

Keep reading

Excel Functions A–ZAREAS Function in Excel: How Many Blocks in a ReferenceExcel Functions A–ZIFNA Function in Excel: Handle “Not Found” OnlyExcel Functions A–ZCOS Function in Excel: Cosine of an Angle
✨ Ask AI about this article

Stuck on a step? Ask a question and the AI answers using this article.

Free · AI can be wrong