Text.Proper

Syntax

Text.Proper(text as nullable text, optional culture as nullable text) as nullable text

Description

Returns the result of capitalizing only the first letter of each word in text value text. All other letters are returned in lowercase. An optional culture may also be provided (for example, “en-US”).

Reference Data

https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference

Power Query M Functions / Text Functions / Text.Proper