Quantunet.com

My Account

Joins Us
Excel QuickSkills
The UPPER() Function Knowledgebase  

 

The UPPER function converts lower case text to upper case.

  • The syntax for the function is UPPER(text) where "text" is a string of text that is to be converted to upper case text.

How to use the UPPER() function:

  • Type " =UPPER( "
  • Enter the coordinate of the data cell "B2"
  • Type")" then press the "Enter" key. 
 


The UPPER function can also convert text directly e.g. UPPER("hello") = HELO. Any numbers or non text characters are ignored and remain unchanged by the function.



© 2007 Quantunet LLC All Rights Reserved | Intellectual Property | Terms of Use | Privacy
Home | About Quantunet | FAQ's | Contact Us