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!