# 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.

# Capitalize only the first letter in Excel

How to capitalize only the first letter in Excel?

# CAPITALIZE ONLY FIRST LETTER — EXCEL FORMULA AND EXAMPLE

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

• UPPER(LEFT(A2,1)) = extract first letter and change it to upper case

• RIGHT(A2,LEN(A2)-1) = extract all the text except the first letter

• & = join the first and second part

# Capitalize only the first letter in Google Sheets

How to capitalize only the first letter in Google Sheets?

# CAPITALIZE ONLY FIRST LETTER — GOOGLE SHEETS FORMULA AND EXAMPLE

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

• UPPER(LEFT(A2,1)) = extract first letter and change it to upper case

• RIGHT(A2,LEN(A2)-1) = extract all the text except the first letter

• & = join the first and second part