Formulas > =PROPER()
How to Use PROPER() in Google Sheets
Description
How To Actually Use PROPER() in Sheets
PROPER(text_to_capitalize)
Try PROPER yourself
In the range A1:A10, enter names in lowercase. Use the PROPER formula in cell B1 to capitalize each name correctly. Drag the formula down to B10.
Hints (2)
-
Remember to reference the correct cell for each name.
-
Use the fill handle to apply the formula to other cells.
Better Sheets Tutorial
Build a Case Converter From Scratch
Create a little web app, or a tool inside of Google Sheets that can take any text input and give us the correct case we want. It can do Title Case or Sentence Case. It can do UPPER and lower case as well.
I added a little apps script to it that will check only one of the options. Check out the Radio Button Apps Script in another video.
I added a little apps script to it that will check only one of the options. Check out the Radio Button Apps Script in another video.
Benoit Asks: How to Convert Case
How can I use this function, lower, upper, or proper as a conditional formatting? And then the other question is, how can I use this to apply on a bunch of cells without having to double the cells?
Create a Headline Generator
Learn to create lead magnet or sellable worksheets for your business. Included are more topic ideas so you can take this template and run with it.
Build Your Own PROPER() Custom Apps Script Function to Capitalize Each Word
There's something wrong with PROPER() the google sheets function. Let's fix it by customizing our own TitleCase() function inside of Apps Script.
More related tutorials
Transcript-matched member videos for PROPER(). Click through to watch.
Calculate ROAS in Google Sheets
How to Iterate Counting Blank Cells in Google Sheets
Write Apps Script to Create a New Google Sheets Formula
Learn more about the PROPER() formula:
Generate a PROPER() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses PROPER(). 2 free AI generations, no signup. Members get unlimited use.
Generate a PROPER() formula