Power Query
published
Search
⌃K

Replacer.ReplaceText

Replacer.ReplaceText

Replaces text within the provided input.
function (optional text as nullable any, old as text, new as text) as nullable any

Description

Replaces the old text in the original text with the new text. This replacer function can be used in List.ReplaceValue and Table.ReplaceValue.

Category

Replacer

Examples

Replace the text "hE" with "He" in the string "hEllo world".
Replacer.ReplaceText("hEllo world","hE","He")
"Hello world"