Search This Blog

25 January 2016

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

 uppercase



capital letters uppercase  lower case  lowercase 



3 comments:

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

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

    ReplyDelete
  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 http://www.trustessays.com/write-my-essay daily reports.

    ReplyDelete