Google Sheets PROPER Function

This post will guide you how to use Google Sheets PROPER function with syntax and examples.

Description


The Google Sheets PROPER function capitalizes the first character in each word of a text string and set other characters to lowercase .

The PROPER function can be used to capitalize each word in a specified text string in google sheet. And you need to know that numbers, spaces and punctuation are not affected in this function.

The PROPER function is a build-in function in Google Sheets and it is categorized as a Text Function.

Syntax


The syntax of the PROPER function is as below:

= PROPER (text)

Where the PROPER function arguments are:

  • text -This is a required argument. The text string that you want to convert to lowercase.

Note: 

  • The PROPER function only takes one argument. It capitalizes each word in a given text string. And one argument can be a text string or a cell reference. The PROPER function will lowercase any uppercase letters firstly, and then capitalize each word in the given text string in google sheets.
  • Numbers characters inside a text string are not affected in LOWER function.
  • Spaces and punctuation character are also not affected in LOWER function.

Google Sheets PROPER Function Examples


The below examples will show you how to use google sheets PROPER function to set the first character to uppercase in each word and set the rest characters in each word to lowercase.

#1 To proper case of the text string in B1 cell, just using formula:

 =PROPER (B1)

google sheets proper function1

#2 Using PROPER function to convert a text string containing numbers or punctuation characters, just using formula:

=PROPER("gOogle sheet-2021")  //it returns “Google Sheet-2021”

google sheets proper function1

Note:

You can use the LOWER function to convert a specified string to lowercase in Google Sheets. And you can also use another function called UPPER function to convert a specified string to uppercase. And if you wish to capitalize each wrd in a specified string, you can use the PROPER function in google sheets.

 

 

 

 

 

 

Related Posts

Google Sheets COLUMN Function
google sheets column function1

This post will guide you how to use Google Sheets COLUMN function with syntax and examples. Description The Google Sheets COLUMN function returns the first column number of the given cell reference. For example, COLUMN(B4) returns 2, as C is ...

Google Sheets CHOOSE Function
google sheets choose function1

This post will guide you how to use Google Sheets CHOOSE function with syntax and examples. Description The Google Sheets CHOOSE function returns a value from a list of values based on index. For example, =CHOOSE(2,”google”,”sheets”,”book”) returns “sheets” value, and ...

Google Sheets ADDRESS Function
google sheets address function1

This post will guide you how to use Google Sheets ADDRESS function with syntax and examples. Description The Google Sheets ADDRESS function returns a reference as a text string to a single cell. For example, =ADDRESS(2,3) returns $C$2. The ADDRESS ...

Google Sheets YEARFRAC Function
google sheets yearfrac function1

This post will guide you how to use Google Sheets YEARFRAC function with syntax and examples. Description The Google Sheets YEARFRAC function returns the number of years between two dates including fractional years. And you can use this function to ...

Google Sheets YEAR Function
google sheets year function1

This post will guide you how to use Google Sheets YEAR function with syntax and examples. Description The Google Sheets YEAR function returns a four-digit year from a given date value, the year is returned as an integer ranging from ...

Google Sheets WORKDAY.INTL Function
google sheets workday.intl function1

This post will guide you how to use Google Sheets WORKDAY.INTL function with syntax and examples. Description The Google Sheets WORKDAY.INTL function returns the serial number of the date before or after a specified number of workdays. And this function ...

Google Sheets WORKDAY Function
google sheets workday function1

This post will guide you how to use Google Sheets WORKDAY function with syntax and examples. Description The Google Sheets WORKDAY function returns a date or a serial number that represents a date that is the indicated number of working ...

Google Sheets WEEKNUM Function
google sheet weeknum function1

This post will guide you how to use Google Sheets WEEKNUM function with syntax and examples. Description The Google Sheets WEEKNUM function returns the week number of a specific date, and the returned value is ranging from 1 to 53. ...

Google Sheets WEEKDAY Function
google sheet weekday function1

This post will guide you how to use Google Sheets WEEKDAY function with syntax and examples. Description The Google Sheets WEEKDAY function returns an integer value representing the day of the week for a given date and the value is ...

Google Sheets TIMEVALUE Function
google sheets timevalue function1

This post will guide you how to use Google Sheets TIMEVALUE function with syntax and examples. Description The Google Sheets TIMEVALUE returns the decimal number of the time represented by a text string. It will convert a time represented by ...

Sidebar