Changing Case in Excel
The Cheaty Method
- Select the offending column
- Copy it
- Open Word
- Paste the column into a new document in Word
- Select the pasted data
- Choose Format>Change case
- Copy the data again
- Paste the column back into Excel
The Clever MethodUse the UPPER, LOWER, or PROPER functions to do this task.
So, if you have offending text in cell A2, you could use the following:
- =UPPER(A2) Changes text to all UPPERCASE (NANCY DAVOLIO)
- =LOWER(A2) Changes text to all lowercase (nancy davolio)
- =PROPER(A2) Changes text to Title Case (Nancy Davolio)
{mosimage} OpenOffice users have it even easier.In OpenOffice , because Writer and Calc are far more integrated, you get Writer functions in Calc. Thus, choose the offending text, choose Format>Change case. And hey-presto!
