Use the formula `=PROPER(A1)`
Replace `A1` with the cell containing the text
Press Enter
Copy the formula down for other cells
Copy the results
Paste Special as Values if you want to replace the original text
Use Flash Fill if you want Excel to learn the pattern manually