Power Query
published
Search
⌃K

Text.Replace

Text.Replace

Replaces all occurrences of the given substring in the text.
function (optional text as nullable any, old as text, new as text) as nullable any

Description

Returns the result of replacing all occurrences of text value old in text value text with text value new. This function is case sensitive.

Category

Text.Modification

Examples

Replace every occurrence of "the" in a sentence with "a".
Text.Replace("the quick brown fox jumps over the lazy dog", "the", "a")
"a quick brown fox jumps over a lazy dog"