insert

Use the insert function to insert a Text value within another Text value at a index position you specify. The insert function returns a Text value.

Function format

insert(Text source, Integer index position, Text value)

  • source: the Text value which the second Text value parameter is added to.
  • index position: the place in the Text source to insert the second Text value parameter. The index is zero-based.
  • value: the value added to the Text source in the Integer index position.

insert example

insert("Hello!", 5 ", world!")

The formula returns the Text value Hello, world!