What is PROPER called in Spanish?

In Spanish Google Sheets it is NOMPROPIO. The formula =PROPER(A2) is written =NOMPROPIO(A2) (or with commas under a Mexico locale).

Why does PROPER use semicolons in some spreadsheets?

It depends on each spreadsheet's locale, under File > Settings. Where the comma is the decimal mark (Spain, much of South America), arguments are separated by semicolons. Mexico and United States locales use commas.

Google Sheets PROPER function

Capitalizes the first letter of each word and lowercases the rest. In Spanish Sheets it is called NOMPROPIO.

Syntax

English Sheets

=PROPER(text_to_capitalize)

Spanish Sheets (Mexico locale)

=NOMPROPIO(texto_mayúsculas)

Spanish Sheets (Spain, Latin America)

=NOMPROPIO(texto_mayúsculas)

Argument	What it is
text_to_capitalize	The text to convert.

Example

UPPER makes everything uppercase, LOWER lowercase, and PROPER capitalizes each word. Handy for cleaning up hand-typed lists or Google Forms responses.

=PROPER(A2)

Common mistake

It also capitalizes after apostrophes and hyphens: "o'brien" gives "O'Brien".

About Ads

This site uses Google AdSense to display ads. These ads help us keep WebHerramientas completely free. Ads are managed by Google and meet strict security and privacy standards.

Practice PROPER

Type the formula in the sheet and check it instantly. Spanish or English function names both work. See all lessons

Your progress0/59

My spreadsheet is inGoogle Sheets functions in English and Spanish

PROPER, UPPER and LOWER

UPPER makes everything uppercase, LOWER lowercase, and PROPER capitalizes each word. Handy for cleaning up hand-typed lists or Google Forms responses.

Example=PROPER(A2)NOMPROPIO = PROPER

In B2, write the name with each word capitalized (María López).

	A	B
1	As typed	Clean
2	mARÍA lópez
3	JOSÉ HERNÁNDEZ
4	lucía martínez
5	aNDRÉS gARCÍA
6	paola RAMÍREZ
7

Tip: while typing, click a cell or drag across several to insert their reference.

Frequently asked questions

What is PROPER called in Spanish?: In Spanish Google Sheets it is NOMPROPIO. The formula =PROPER(A2) is written =NOMPROPIO(A2) (or with commas under a Mexico locale).
Why does PROPER use semicolons in some spreadsheets?: It depends on each spreadsheet's locale, under File > Settings. Where the comma is the decimal mark (Spain, much of South America), arguments are separated by semicolons. Mexico and United States locales use commas.
What is the most common PROPER mistake?: It also capitalizes after apostrophes and hyphens: "o'brien" gives "O'Brien".