If you get Excel tables from different sources, your data are likely to be discordant. You can run the Change Case app to make all cells look right at once:
Please note that any formulas in your range will be overwritten with values. You can cancel the process to keep them, or continue and have the values inserted.
One click will change lower case to upper case, capitalize cells, and make words take proper case. Simply select the cells, the case you need and click Run on the app pane.
The Change Case App is your simple way to convert words in the selected Excel cells to upper, lower, or proper case.