How would you like to MASTER graphic design by next week?
Click here to find out how
Featured Photoshop templates - professional ready to use designs for your next project
View all templates
Excel Upper Tutorials
Force Text to Upper- or Proper Case
Restrict all future entries in a spreadsheet or range of cells to uppercase or proper case only.
Change Text to Upper- or Proper Case
When using a built-in Excel function is impractical, you can use a custom macro to change any existing text to uppercase or proper case.
Upper to Lower Case Function “=PROPER()”
The following formula easily tranforms a list of data from Upper to Lower case. This is has come in handy several times.
LOWER, UPPER and PROPER functions in Excel
These text functions give you the ability to change the capitalization (case) of cells to being all lower, or all UPPER, or Proper.