remove

Use the remove function remove characters from a Text value. You can specify the position in the Text value to remove the characters from, and you can specify the number of characters you remove from the Text value. The remove function returns a Text value.

Function format

remove(Text source, Integer index position, Integer length)

• source: the Text value which characters are removed from.
• index position: the place in the Text source to begin to remove the characters from. The index is zero-based.
• length: the number of characters to remove from the Text source.

remove example

remove("12300", 4, "2")

The formula returns the Text value 123.