In this tutorial we will be changing the case of existing text within our Excel spreadsheet. Excel provides a few different options in this regard which are.
- Proper – This will apply the appropriate case where the first letter of the cell will be upper case whilst the rest will be lower case.
- To do this type =PROPER(A1), then press Enter.
- This will apply the proper case to all characters within cell A1. The first character will be upper case and all following will be lower case.
- Lower – This will change all charecters within the cell to lower case.
- To do this type =LOWER(A1), then press Enter.
- This will apply the lower case to all character’s within cell A1.
- Upper – This will change all charecters within the cell to upper case.
- To do this type =UPPER(A1), then press Enter.
- This will apply the upper case to all character’s within cell A1.