How to Change Text Case in MS Excel

‍

‍

Here's how to do it:

‍

1. Open the file you want to edit.
2. Click on the cell where you want the changes to be applied, type an equals sign followed by the word 'LOWER', and then select the cell of choice. For example, =LOWER(A3).
3. Click the bottom corner of the cell and drag to highlight the rest of the names or words you wish to modify.
4. As you can see the names are now all in lower case.