Learn how to easily convert text to capital letters using Excel’s UPPER function.
🧠 क्या सीखेंगे:
- What is UPPER Function?
- Why is it useful?
- How to use it with examples?
- Practice Assignments
The UPPER function is a text function that is used to convert all the letters in a text string to uppercase. This can be useful in various situations where you need to ensure that text is consistently in uppercase format, regardless of how it was originally entered.
Syntax
=UPPER(text)
text: This is the text string that you want to convert to uppercase. It can be a reference to a cell containing text or a text string enclosed in double quotation marks.
Example
📝 Student Assignments for Practice
Assignment 1: Name Capitalization
Objective: Convert all names to uppercase.
Data:
| Name |
|---|
| amit kumar |
| sneha mehta |
| deepak joshi |
| priya singh |
👉 Task: Use the UPPER function in a new column to convert each name into capital letters.
Assignment 2: Product Titles in Uppercase
Objective: Standardize product titles.
Data:
| Product Name |
|---|
| wireless mouse |
| gaming keyboard |
| laptop bag |
| bluetooth speaker |
👉 Task: Use the UPPER function to convert all product names into uppercase for a professional look.