Fonction Google Sheets

PROPER

Capitalizes the first letter in each word of a text string and converts all other letters to lowercase.

Générer une formule avec l'IA La même fonction dans Excel

Cette fonction fonctionne de la même façon dans Google Sheets que dans Excel — même syntaxe et mêmes arguments.

Syntaxe

PROPER(text)

The PROPER function is useful for formatting names, titles, or addresses that have inconsistent casing. It treats any character that is not a letter as a word separator, ensuring that the character immediately following it is capitalized.

Arguments

textobligatoireThe text string you want to convert to proper case.

Exemples

=PROPER("excel IS FUN")

Résultat : Excel Is Fun

Converts the all-caps string into proper case.

=PROPER("john doe")

Résultat : John Doe

Capitalizes the first letter of both 'john' and 'doe'.

FAQ

Does PROPER handle special characters?

Yes, it treats non-letter characters as separators and capitalizes the letter immediately following them.

Fonctions associées

UPPER LOWER TRIM