← Back to Text functions

Text.Insert

This function returns the outcome of inserting a new text value (newText) into an existing text value (text) at a specific position (offset). Positions are numbered starting from 0.

Syntax

Text.Insert(text as nullable text, offset as number, newText as text) as nullable text

About

This function returns the outcome of inserting a new text value (newText) into an existing text value (text) at a specific position (offset). Positions are numbered starting from 0.

Explanation

Add the letter "C" between "B" and "D" in the sequence "ABD" using the Power Query MText function. This will result in the output "ABCD".