Скачать или смотреть Upper and Lowercase

Hello everyone! Welcome back.
Today, we’re going to learn how to convert text into UPPERCASE and lowercase using simple formulas in Excel! 🚀

If you’re working with names, titles, or any text data, these formulas will save you tons of time. Let’s dive right in!

📌 SECTION 1: UPPERCASE FORMULA
(🎥 Screen recording starts)
Host:
First, let’s see how to change all text into capital letters.

📌 Here’s the formula:
=UPPER(A1)

👉 Step-by-Step:
1️⃣ Click on an empty cell where you want the result.
2️⃣ Type =UPPER(A1), where A1 is the cell with your text.
3️⃣ Press Enter, and boom! Your text is now in ALL CAPS! 🎉

🔹 Example: If A1 contains “hello world” → The formula will return “HELLO WORLD”

📌 SECTION 2: LOWERCASE FORMULA
Host:
Now, let’s make all text lowercase.

📌 Use this formula:
=LOWER(A1)

👉 Steps:
1️⃣ Click on an empty cell.
2️⃣ Type =LOWER(A1).
3️⃣ Press Enter—now your text is in all lowercase!

🔹 Example: If A1 has “HELLO WORLD” → The formula will return “hello world”


👍 If you found this helpful, LIKE, SHARE, and SUBSCRIBE for more Excel tips! Let me know in the comments what you’d like to learn next. 🚀

🔔 Hit the bell icon so you never miss an update! See you in the next video! 🎥✨

#ExcelTips #UpperCaseLowerCase #ExcelShortcuts