How to convert all letters into Uppercase in Microsoft Excel / Use of UPPER Function (Formula) in Microsoft Excel


UPPER


Use of UPPER Formula in Microsoft Excel:

This formula/function convert all lowercase letter/word in particular cell to uppercase.


Syntax/Formula:

=UPPER(text)



Examples:

Step 1 : First type advancedmsexcel.blogspot.com in cell B4

Step 2 : Type formula =UPPER(B4) in cell B6 and press Enter.



UPPER




No comments:

Post a Comment