Power Query
published
Search
⌃K

Text.ReplaceRange

Text.ReplaceRange

Removes a range of characters and inserts a new value at a specified position.
function (optional text as nullable any, offset as number, count as number, newText as text) as nullable any

Description

Returns the result of removing a number of characters, count, from text value text beginning at position offset and then inserting the text value newText at the same position in text.

Category

Text.Modification

Examples

Replace a single character at position 2 in text value "ABGF" with new text value "CDE".
Text.ReplaceRange("ABGF", 2, 1, "CDE")
"ABCDEF"