Capitalize First Letter – Excel & Google Sheets

Written by

Editorial Team

Reviewed by

Steve Rynearson

Last updated on August 17, 2023
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 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

AI Formula Generator

Try for Free

Excel Practice Worksheet

practice excel worksheet

Practice Excel functions and formulas with our 100% free practice worksheets!

  • Automatically Graded Exercises
  • Learn Excel, Inside Excel!

Free Download

Return to Excel Formulas List