Text.Replace

This function returns the outcome of substituting all instances of the old text value with the new text value in the specified text. It is important to note that this function distinguishes between lo...

Syntax

Text.Replace(text as nullable text, old as text, new as text) as nullable text

About

This function returns the outcome of substituting all instances of the old text value with the new text value in the specified text. It is important to note that this function distinguishes between lowercase and uppercase letters.

Explanation

Substitute each instance of "the" within a sentence with "a". Employ Power Query MText.Replace("the quick brown fox jumps over the lazy dog", "the", "a") to receive the resultant "a quick brown fox jumps over a lazy dog".