← Back to Text functions

Text.ReplaceRange

This function returns the outcome of eliminating a specified quantity of characters, count, from the text value text starting at position offset. Afterwards, it inserts the text value newText at the s...

Syntax

Text.ReplaceRange(text as nullable text, offset as number, count as number, newText as text) as nullable text

About

This function returns the outcome of eliminating a specified quantity of characters, count, from the text value text starting at position offset. Afterwards, it inserts the text value newText at the same position in the text.

Explanation

In this operation, we are updating a specific character in a text value. The character at position 2 in the text value "ABGF" will be replaced with the new text value "CDE". To achieve this, we will use the Power Query MText.ReplaceRange function. After performing the operation, the output will be "ABCDEF".