upper

 The UPPER function in Excel is used to convert text to uppercase. Below are 10 examples of how you can use the UPPER function, including data and formulas:

Example 1: Basic UPPER Function

Data:
A1: hello world

Formula:
=UPPER(A1)

Result:
HELLO WORLD

---

Example 2: UPPER with Concatenation

Data:
A1: john
B1: doe

Formula:
=UPPER(A1 & " " & B1)

Result:
JOHN DOE

---

Example 3: UPPER with IF Function

Data:
A1: Yes

Formula:
=IF(A1="Yes", UPPER("Confirmed"), UPPER("Denied"))

Result:
CONFIRMED

---

Example 4: UPPER with TEXTJOIN

Data:
A1: apple
B1: banana
C1: cherry

Formula:
=UPPER(TEXTJOIN(", ", TRUE, A1:C1))

Result:
APPLE, BANANA, CHERRY

---

Example 5: UPPER with LEFT Function

Data:
A1: excel

Formula:
=UPPER(LEFT(A1, 3))

Result:
EXC

---

Example 6: UPPER with RIGHT Function

Data:
A1: excel

Formula:
=UPPER(RIGHT(A1, 3))

Result:
CEL

---

Example 7: UPPER with MID Function

Data:
A1: excel

Formula:
=UPPER(MID(A1, 2, 3))

Result:
XCE

---

Example 8: UPPER with SUBSTITUTE Function

Data:
A1: hello world

Formula:
=UPPER(SUBSTITUTE(A1, "world", "earth"))

Result:
HELLO EARTH

---

Example 9: UPPER with TRIM Function

Data:
A1: hello world

Formula:
=UPPER(TRIM(A1))

Result:
HELLO WORLD

---

Example 10: UPPER with PROPER Function

Data:
A1: john doe

Formula:
=UPPER(PROPER(A1))

Result:
JOHN DOE

---

These examples demonstrate how the UPPER function can be combined with other Excel functions to manipulate and transform text data.