How to change Case-sensitive in Ms.Excel/how to change words into upper (or) lower case in excel

Hello Guys, Today i am going to explain about Case-Sensitive in Microsoft Excel.Before that i want say you  in Microsoft word there is an option to change the characters in to Uppercase (or) Lowercase. check the figure right now below.

But in excel we need to use formula to change Uppercase to Lowercase & the same for Lowercase to Uppercase.its a very simple formula to kept in memory.below  check the below animated image to learn how i use those formulas to change Case-Sensitive.

Hope you guys are understood sure.let me know about your thoughts.put a comment below.