Text.Proper

The function will capitalize the initial letter of each word in the provided text while converting all other letters to lowercase. It also allows the inclusion of an optional culture parameter, such a...

Syntax

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

About

The function will capitalize the initial letter of each word in the provided text while converting all other letters to lowercase. It also allows the inclusion of an optional culture parameter, such as "en-US".

Explanation

Apply the Text.Proper function to a basic sentence using Power Query M language. Result: "The Quick Brown Fox Jumps Over The Lazy Dog"