Capitalize the only first letter in Excel and Google Sheets

=UPPER(LEFT(A2,1))&RIGHT(A2,LEN(A2)-1)

A2 = cell which you want to Capitalize the only first letter

Check below for a detailed explanation with pictures and how to use formulas in Excel and Google Sheets.