In cell B2, type =PROPER(A2), then press Enter.
Source: Change the case of text – Office Support
Your email address will not be published. Required fields are marked *
Save my name, email, and website in this browser for the next time I comment.