Text.Proper
TextCapitalizes the first letter of each word in a text value.
Syntax
Text.Proper(text as nullable text, optional culture as nullable text) as nullable textParameters
| Name | Type | Required | Description |
|---|---|---|---|
text | text | Yes | The text value to convert to proper case. |
culture | text | No | A culture code (e.g., "en-US") that determines locale-specific casing rules. |
Return Value
text — The input text with the first letter of each word capitalized and the rest lowercased.
Remarks
Text.Proper converts text to title case — the first letter of each word is capitalized and the remaining letters are lowercased. This is ideal for cleaning up names and titles that have inconsistent casing.
Note that Text.Proper treats any non-letter character as a word boundary, so hyphens, apostrophes, and other punctuation trigger capitalization of the next letter.
Examples
Example 1: Proper case employee names
Table.TransformColumns(
Table.SelectColumns(Employees, {"FullName"}),
{"FullName", Text.Proper, type text}
)Result
FullName | |
|---|---|
| 1 | Alice Smith |
| 2 | Bob Jones |
| 3 | Charlie Brown |
| 4 | Diana Prince |
| 5 | Eve Martinez |
| 6 | Frank Lee |
Compatibility
✓ Power BI Desktop✓ Power BI Service✓ Excel Desktop✓ Excel Online✓ Dataflows✓ Fabric Notebooks