Friday 30 August 2019

Upper Function in Excel

If you have written a message in lowercase letters and you want to change it to uppercase letters, then Upper function is for you. Upper function in excel converts the text in Uppercase.


Syntax of Upper Function is

=UPPER(Text)


 In the example, I have taken 4 text strings in the column and apply a function (=Upper(A1)) in Column B. All lowercase characters are converted to uppercase, Number and special characters are unaffected.

No comments:

Post a Comment