2 Ways to Change Case of Text in Excel (Lowercase, Uppercase, Propercase)

Опубликовано: 04 Октябрь 2024
на канале: The Akshay
1,258
8

Use the UPPER, LOWER, or PROPER formulas to change the case of text to uppercase, lowercase, or proper case.

=LOWER(A2) : convert all letters in a string to lowercase.

=UPPER(A2) : convert all letters in a string to uppercase.

=PROPER(A2) : convert the first letter in each word in uppercase, and all other letters in lowercase.

Convert caps to small or small to caps in Excel.

Feel free to comment your questions. You can also request topics.

Connect with me on :
Twitter :   / the_akshay_1  
FB :   / theakshay2  

#PROPER #UPPER #LOWER #Excel #Excel_Series