Fabric Plan Community Logo
Sign in

PROPER

The PROPER function converts the first character of each word in a text string to uppercase and converts the remaining characters to lowercase. This function is commonly used to format text in proper case.

Syntax

PROPER(value)

Arguments

  • value: The text string to convert to proper case.

Return value

Returns the text string in proper case.

Example

PROPER("annual SALES report")

Returns Annual Sales Report.

Excel equivalent

PROPER

Fabric Plan
Enterprise planning, integrated with PowerTable and Intelligence, native to Microsoft Fabric. Co-engineered with Lumel.
CERTIFIED BY
Fabric Planning is certified by IBCS
Microsoft, Azure, Copilot, Excel, Fabric IQ, Microsoft Entra, Microsoft Fabric, Microsoft Teams, OneLake, Outlook, Power Automate, Power BI and SharePoint are trademarks of the Microsoft group of companies. IBCS is a registered trademark of IBCS Association. All other trademarks are the property of their respective owners.

This community is operated independently by Lumel. Nothing on this site constitutes a representation or warranty by Microsoft.