Name
PROPER
Synopsis
Use PROPER to capitalize the first letter in a string and any other letters that are preceded by a non-letter character. All other letters are converted to lowercase. For example, “This is a BOX” is converted to “This Is A Box.”
To Calculate
=PROPER(Text
)
Example
Figure 18-5 illustrates how to use PROPER to convert a string so that only the first letter of each word is capitalized.
Get Excel 2000 in a Nutshell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.