Luckily, Excel offers handy formulas that allow you to convert text into upper case ... Feed it a cell reference or text ...

The easiest way to capitalize text in Excel is by using the PROPER function. It capitalizes the first letter of each word in a text string while converting all other letters to lowercase.