Home

Microsoft Excel [email protected]

Microsoft Excel 2007

Microsoft Excel 2003

Forums

Microsoft Excel 2003 Functions and Formulas

Convert a Cell's Value to Uppercase or Lowercase

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.

Print this tip.

- Subscribe!

Search the Site: