Testo

Funzione Excel PROPER

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

Sintassi

PROPER(text)

Genera PROPER con l'IA Tutte le funzioni

Argomenti

textobbligatorio

The text string you want to convert to proper case.

Cosa fa la funzione PROPER

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.

Esempi

=PROPER("excel IS FUN")→Excel Is Fun

Converts the all-caps string into proper case.

=PROPER("john doe")→John Doe

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

Come usare PROPER

Select the cell

Click on the cell where you want the converted text to appear.

Enter the formula

Type =PROPER( followed by the cell reference containing the text, then press Enter.

Domande frequenti

Does PROPER handle special characters?

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

Funzioni correlate

UPPER LOWER TRIM