Return to Excel Formulas List

Capitalize First Letter – Excel & Google Sheets

Download Example Workbook

Download the example workbook

This tutorial will teach you how to capitalize first letter(s) in Excel and Google Sheets.

capitalize first letter Main Function

Capitalize First Letter of All Words

The simplest way to capitalize first letters in a text string is to use the PROPER Function.

capitalize first letter proper

The PROPER Function capitalizes the first letter in every word in the text string and convers all other letters to lower case.

Note: The PROPER Function treats any non-numeric character like a space. So “joe2smith” was changed to “Joe2Smith”.

Capitalize First Letter Only

Instead, to capitalize only the first letter of your text string, use the REPLACE function along with the UPPER and LEFT functions.

capitalize first letter proper

The REPLACE Function simply replaces the first character with a capitalized version of the first character.

You can add in the LOWER Function to set all other characters to lower case:

capitalize first letter UP Lower

Capitalize First Letter in Google Sheets

These formulas work exactly the same in Google Sheets as in Excel.

 

capitalize first letter Google Function