How does PROPER handle hyphenated or apostrophe-containing words?

PROPER treats the character after a hyphen, apostrophe or space as the start of a new word, so "co-op" becomes "Co-Op" and "chef's" becomes "Chef'S". If you need finer control, combine PROPER with SUBSTITUTE to replace the delimiter temporarily.

Can PROPER be used on numbers, dates or Boolean values?

PROPER will coerce numbers and dates to text but will not change their visual representation; the result looks identical to the input. For formatting numbers or dates you should use TEXT or the dedicated number-formatting functions.

Why does PROPER return #VALUE! when I reference an entire column?

Older versions of Excel expect a single scalar argument, so referencing a whole column (e.g., =PROPER(A:A)) triggers #VALUE!. In Excel with dynamic arrays the same formula returns an array of title-cased strings. Use a helper column or upgrade to a newer version for automatic spilling.

Is PROPER aware of non-English characters like é, ñ, or ß?

Yes. PROPER respects the workbook’s locale and will correctly capitalise characters with diacritics, such as turning "jalapeño" into "Jalapeño". However, language-specific rules (e.g., Turkish dotted-i) depend on the system’s language settings.

PROPER function

PROPER converts a text string to title case, capitalising the first letter of each word while making all other letters lower-case.

=PROPER(text)

Generate a PROPER formula

Describe what you need. The generator will reach for PROPER where PROPER is the right tool, and tell you when it is not.

Arguments

How PROPER reads its arguments

Argument	Required	Description
text	Required	A required text argument; can be a string, a reference to a single cell, or a scalar value. Non-text values are coerced, but a multi-cell range triggers an error in legacy Excel.

Returns

A single text string (or an array of text strings) with title-cased words.

Availability

Excel: All · Google Sheets: Supported

Worked examples

1. Standardise ingredient names

Ingredient	Supplier	Unit	Qty	Expiry Date
tomato sauce	fresh farms	kg	10	2024-12-31
OLIVE OIL	oliveCo	L	5	2025-03-15
basil leaves	herbGarden	g	200	2024-06-01

=PROPER(A2)   // A2 contains the raw ingredient name

Result: Tomato Sauce

A2 holds the lower-case entry "tomato sauce". PROPER changes the first character of each word to upper case and leaves the rest lower case, yielding "Tomato Sauce". This is useful for printing clean inventory lists.

2. Create a proper-cased supplier label

Ingredient	Supplier	Unit	Qty	Expiry Date
tomato sauce	fresh farms	kg	10	2024-12-31
OLIVE OIL	oliveCo	L	5	2025-03-15
basil leaves	herbGarden	g	200	2024-06-01

=PROPER(B3) & " supplies " & PROPER(A3)

Result: Oliveco supplies Olive Oil

B3 contains "oliveCo" and A3 contains "OLIVE OIL". PROPER converts each to title case, producing "Oliveco" and "Olive Oil". Concatenating with the static text " supplies " yields a readable label for a stock-take report.

3. Generate a proper-cased expiry notice

Ingredient	Supplier	Unit	Qty	Expiry Date
tomato sauce	fresh farms	kg	10	2024-12-31
OLIVE OIL	oliveCo	L	5	2025-03-15
basil leaves	herbGarden	g	200	2024-06-01

=PROPER(A4 & " - " & TEXT(E4, "yyyy-mm-dd"))

Result: Basil Leaves - 2024-06-01

A4 holds "basil leaves" and E4 holds the serial date for 1 June 2024. TEXT formats the date as a string, the ampersands concatenate the parts, and PROPER title-cases the ingredient while leaving the ISO date unchanged. The final string is perfect for a shelf-life alert.

Common errors

Which PROPER error are you seeing?

Error	Why it happens	How to fix it
#VALUE!	PROPER was given a multi-cell range (e.g., =PROPER(A2:A4)) in a version of Excel that does not support dynamic arrays.	Apply PROPER to each cell individually (e.g., copy the formula down) or use TEXTJOIN/ARRAYFORMULA in Google Sheets.
#SPILL!	In a modern Excel, =PROPER(A2:A4) returns an array, but cells directly below the formula are already occupied, blocking the spill.	Clear the destination cells where the array would expand, or place the formula in a location with enough empty rows.
#NAME?	The function name was misspelled, such as =PROPR(A2). Excel cannot recognise the identifier.	Correct the spelling to PROPER so the function can be evaluated.

Tips and when to use something else

Use PROPER when you need title-case for headings, product names, or label text; for all-upper or all-lower case, use UPPER or LOWER instead.
Combine PROPER with TRIM to remove leading/trailing spaces before fixing case, e.g., =PROPER(TRIM(A2)).
In legacy Excel, PROPER cannot process an entire column at once; create a helper column and copy the formula down.
If you need to change the case of only the first character of a string, consider using LEFT, UPPER, and RIGHT instead of PROPER.

Related functions

UPPERUPPER converts any supplied text to all capital letters, returning a string of the same length with every alphabetic character in uppercase.LOWERLOWER converts any supplied text to all-lowercase characters, returning a string or an array of strings matching the input shape.TEXTJOINTEXTJOIN merges multiple text strings or ranges into one string, using a chosen delimiter and optional ignoring of empty cells.TRIMTRIM removes all leading and trailing spaces from a text string, returning a clean version without extra blanks.LEFTLEFT returns the leftmost characters from a text string, optionally limited by a specified number of characters.

Frequently asked questions

How does PROPER handle hyphenated or apostrophe-containing words?: PROPER treats the character after a hyphen, apostrophe or space as the start of a new word, so "co-op" becomes "Co-Op" and "chef's" becomes "Chef'S". If you need finer control, combine PROPER with SUBSTITUTE to replace the delimiter temporarily.
Can PROPER be used on numbers, dates or Boolean values?: PROPER will coerce numbers and dates to text but will not change their visual representation; the result looks identical to the input. For formatting numbers or dates you should use TEXT or the dedicated number-formatting functions.
Why does PROPER return #VALUE! when I reference an entire column?: Older versions of Excel expect a single scalar argument, so referencing a whole column (e.g., =PROPER(A:A)) triggers #VALUE!. In Excel with dynamic arrays the same formula returns an array of title-cased strings. Use a helper column or upgrade to a newer version for automatic spilling.
Is PROPER aware of non-English characters like é, ñ, or ß?: Yes. PROPER respects the workbook’s locale and will correctly capitalise characters with diacritics, such as turning "jalapeño" into "Jalapeño". However, language-specific rules (e.g., Turkish dotted-i) depend on the system’s language settings.

Need a different formula?

The full generator is not scoped to one function — describe any spreadsheet problem and it will pick.

Open the formula generator