Summary: Convert text values inside Microsoft Excel 2003 spreadsheets to uppercase or lowercase.
If a particular name needs to be displayed in a Microsoft Excel 2003 spreadsheet as all uppercase or all lowercase, no matter how it was originally entered, you can use the =UPPER and/or =LOWER function(s).
=UPPER("text")
Converts 'text' to uppercase. The text should be surrounded by quotes.
=LOWER("text")
Converts 'text' to lowercase. The text should be surrounded by quotes.
Examples:
=UPPER("excel 2003 function")
EXCEL 2003 FUNCTION
=LOWER("sOmeOne hAvIng caPS locK pRoblEms")
someone having caps lock problems
Add: Del.icio.us |
Digg |
Furl |
My Yahoo!
Last Modified on: July 13, 2008, at 12:04 A.M. EDT
Return to the Microsoft Excel 2003 Functions and Formulas page.
Search the Site: