Change the case of text (convert text from uppercase to lowercase or from lowercase to proper case ) Microsoft Excel doesn't have a Change Case button for changing capitalization. However, you can use the UPPER, LOWER, or PROPER functions.Converts texts , letters to uppercase , lowercase or proper case in excel sheet insert function user can easily change letters case in excel sheet.

Functions that allow you to change the case of text in multiple columns

1-Upper(your cell name) – converts text to all upper case
2-Lower (your cell name) – converts text to all lower case
3-Proper (your cell name) – converts text to proper case, or title case (the first letter of each word is capitalized)

For examples in this video
If this topic is useful or not for you please put your comments


capital letters uppercase  lower case  lowercase