Documentation/How Tos/Calc: PROPER function

CALC FUNCTIONS

Text Functions

< {{#switch:Previous Section

Previous Section = Previous Section

Next Section = Next Section

Previous Page = Previous Page

Next Page = Next Page

}}

{{#switch:Next Section

Previous Section = Previous Section

Next Section = Next Section

Previous Page = Previous Page

Next Page = Next Page

}} >

FUNCTIONS

• Base
• Char
• Clean
• Code
• Concatenate
• Dollar
• Exact
• Find
• Fixed
• Left
• Len
• Lower
• Mid
• Proper
• Replace
• Rept
• Right
• Search
• Substitute
• T
• Text
• Trim
• Upper
• Value

< {{#switch:Previous Page

Previous Section = Previous Section

Next Section = Next Section

Previous Page = Previous Page

Next Page = Next Page

}}

{{#switch:Next Page

Previous Section = Previous Section

Next Section = Next Section

Previous Page = Previous Page

Next Page = Next Page

}} >

PROPER

returns text with words in lowercase after a capitalised first letter.

Syntax:

PROPER(text)

returns text with the first character of each word capitalised, and other characters in lower case.

Example:

PROPER("gooD morNINg")

returns Good Morning.