PROPER, UPPER, and LOWER functions in EXCEL🔥
1. PROPER Function:
The PROPER function converts the first letter of each word in a text string to uppercase and converts the remaining letters to lowercase.
It's commonly used to format names, addresses, or any other text where proper capitalization is required.
Example:
Suppose cell A1 contains the text "hello world." To apply the PROPER function, you can use the following formula in another cell:
=PROPER(A1)
The result will be "Hello World."
2. UPPER Function:
The UPPER function converts all letters in a text string to uppercase.
It's useful when you want to convert an entire text string to uppercase, regardless of the original case.
Example:
Let's assume cell A1 contains the text "hello world." To convert it to uppercase using the UPPER function, you can use the following formula in another cell:
=UPPER(A1)
The result will be "HELLO WORLD."
3. LOWER Function:
The LOWER function converts all letters in a text string to lowercase.
It's useful when you want to convert an entire text string to lowercase, regardless of the original case.
Example:
Consider cell A1 with the text "Hello World." To convert it to lowercase using the LOWER function, you can use the following formula in another cell:
=LOWER(A1)
The result will be "hello world."
Learn more about excel functions in DATA ANALYSIS MADE EASY.
DATA ANALYSIS MADE EASY will teach you:
EXCEL
SQL
POWER BI
PYTHON
Master everything you need to become a data analyst and land yourself a job in less than 4 months.
ALL simplified in one Book.
With:
8 free websites to get remote jobs
A Telegram community of more than 180 learners like YOU
Discount on my new book that will be out this month.
Discount on classes I will be holding soon.
Download it NOW: https://selar.co/bpr5
If you have any issues downloading it, maybe due to your location.
You can make payment to this PayPal mashoodtaofeek@gmail.com, reply this mail and I will send the book to you NOW