Search This Blog

The most effective method to Change Letter Case in Excel sheet

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 


  1. If this topic is useful or not for you please put your comments

  2. pls make lisp for electrical drawing. need some drawing for me.if make lisp for electrical really use for me

  3. I am using excel on a daily basis in doing my work and my reports. There are times that I need to change something asap, good thing I came across your post, now it will be much convenient for me to change letter case in my daily reports.

  4. Thank you so much as you have been willing to share information with us. We will forever admire all you have done here because you have made my work as easy as ABC labels

  5. a reformist site about the intricate details of abstaining from excessive food intake, sustenance and weight reduction.real silk sheets

  6. This is an in depth book review of Excel 2016 Power Programming with VBA by John Walkenbach. This is a book that helped me learn VBA and after reading this I was able to create powerful Excel applications. word translator

  7. You make so many great points here that I read your article a couple of times. Your views are in accordance with my own for the most part. This is great content for your readers. k√ľndigen