Formulas > =PROPER()
How To Use PROPER() Function 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.
5 Better Sheets Tutorials
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?
ARRAYFORMULA()
LOWER()
PROPER()
UPPER()
Capitalize Each Word
Every word can be capitalized with this formula.
LOWER()
PROPER()
UPPER()
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.
CONCATENATE()
PROPER()
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.
IF()
LOWER()
PROPER()
UPPER()
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.
PROPER()
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