Function Upper()

Upper()

This function is used to convert the text in UPPER case (upper case means capital letters)

Syntax:

= Upper (Text)

Text = is the text, or reference to a cell that contains the text, that is required to be converted to UPPER case

Example:

Below are some examples to illustrate the usage of Upper() function. For these illustrations let us assume that cell A1 contains text - Excel Matic

• = Upper("hello world") - result will be - HELLO WORLD
• = Upper("HeLlO WoRlD") - result will be - HELLO WORLD
  
• = Upper(A1) - result will be - EXCEL MATIC

Note: this function can take text in any case to convert to upper case

Share on Facebook Share on Twitter Share on Google Plus

About Dhakkanz

This is a short description in the author block about the author. You edit it by entering text in the "Biographical Info" field in the user admin panel.