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 the first letter in Excel
CAPITALIZE ONLY FIRST LETTER — EXCEL FORMULA AND EXAMPLE
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 the first letter in Google Sheets
CAPITALIZE ONLY FIRST LETTER — GOOGLE SHEETS FORMULA AND EXAMPLE
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
Other useful Google and Excel functions for changing the text position
- Flip the first and last name
- Move the first word to the end
- Reverse the text strings within cells
- Capitalize the first letter of every word
- Split words by uppercase in Google Sheets
- Sum by month
- SUMIF cells if contains part of a text string
- Sum total sales based on quantity & price
- Combine date and time
- Convert 1-12 to month name
- Dynamic current date and time
- Count blank cell
- Count cell between two values
- Combine two or more cell
- Extract left before first space
- Extract the nth words in a text string
- SUMIF formulas and example
- SUMIFS formulas and example
- COUNTIF formulas and example
- IF formulas and example
- TEXT formulas and example
- CONVERT formulas and example
- Change the negative number to zero
- Change negative to positive numbers
- Calculate percentage changes for containing zero or negative values
- Convert date to text
- Convert time to text
- Convert weekday string to number
- Combine two or more cells with a line break
- Combine two or more cells and transpose
- Count cells over 10 characters
- Count cells that are not blank
- Count if cells contain a specific text
- Count cells that begin with a specific text
- COUNTIF based on multiple criteria