SheetFX
≡
<< Go back to all functions

PROPER

The PROPER function in Google Sheets is a convenient tool to capitalize each word in a given string. Whether you're formatting names, titles, or any other text, the PROPER function simplifies the task. Discover the step-by-step tutorial below to learn how to apply it.

Function Syntax and Parameters

Syntax: PROPER(text_to_capitalize)

Parameters:

  • text_to_capitalize: The text or cell reference containing the string to capitalize.

Step-by-Step Tutorial

  1. Using PROPER with a single word:

    • Example: =PROPER("hello")
    • Result: Hello

  2. Using PROPER with a sentence:

    • Example: =PROPER("good morning, everyone!")
    • Result: Good Morning, Everyone!

Use Cases and Scenarios

  1. Name Formatting: Capitalize the first letter of each name in a list.
  2. Title Formatting: Format titles by capitalizing each word.
  3. Textual Data Enhancement: Capitalize text imported from external sources.

Related Articles