Nick Davis / @nickyboy
Change text in Excel to Sentence Case
In cell B2, type =PROPER(A2), then press Enter.
Source:
Change the case of text – Office Support