UPPER Function in Excel: Convert Text to Capitals

📎 This article includes 1 downloadable practice file ↓

TextLevel: BeginnerAvailable in: Excel 2007+

In this article

1. Syntax
2. Examples
3. Example 1
4. Example 2
5. UPPER in practice
6. Where you will use it
7. Worked example
8. Mistakes people make
9. Related functions
10. Continue learning

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.

UPPER in practice

Where you will use it

• Standardise codes, PAN and GSTIN
• Make lookups consistent
• Headings

Worked example

Text	Formula	Result
abcde1234f	=UPPER(A2)	ABCDE1234F
inv-2026-0145	=UPPER(A3)	INV-2026-0145
north	=UPPER(A4)	NORTH

Results calculated in Excel.

Mistakes people make

Mistake	What to do instead
Expecting it to remove spaces	Combine with TRIM
Changing names to all caps	Use PROPER for names

Related functions

LOWER · PROPER · EXACT

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

Continue learning

All Text guides →

REGEXREPLACE Function in Excel: Find and Replace With PatternsREGEXREPLACE replaces text matching a pattern — strip every non-digit, collapse repeated spaces, mask…T Function in Excel: Keep Text, Blank Out NumbersT returns text unchanged and anything else as an empty string. Rarely needed alone,…NUMBERVALUE Function in Excel: Convert Text Numbers With Any SeparatorsNUMBERVALUE converts text to a number using separators you specify — essential for European-style…VALUE Function in Excel: Convert Text to a NumberVALUE turns text that looks like a number into a real number, so SUM…

📎 Practice files for this article

• 📗
  Practice workbook: Text & cleaning24 tasks on realistic sales data — type your formula, the Check column turns green when it is right. Answers sheet included.
  ⬇ XLSX · 35 KB

Free to use for learning. Files with macros (.bas) are plain text — import them with Alt+F11 → File → Import File, and always test on a copy.