Transforming the Case (Uppercase, Lowercase) of the Text

There is a small function that we can use to transform the case of our text, the function is quite easy to use, all you need to do for this is that you need to type ‘UPPER(text/cell)’ for upper case, ‘Lower(text/cell)’ for lower case and finally ‘Proper(text/cell)’ for making the first letter of the word capital. Its usage can be seen in the images below, with cells showing Upper, Lower and proper usage along with the final output that they achieve from it.

Transforming the Case 1













Transforming the Case 2














lower Case

Proper case















Proper Case