Category: Text function
This function removes all instances of string from text.
Argument | Type | Description |
---|---|---|
text | Text | Any text value from which the text string is removed. |
string | Text | The text string removed from text. |
Return value type: Text
This function is case sensitive.
Number values entered for text and string are implicitly converted to text.
All instances of string are removed from text.
If string is not found within text, the full value of text is returned.
removetext('Miss Mississippi', 'iss') //Returns 'M Mippi'
removetext('Wellington', 'well') //Returns 'Wellington' ('well' not found due to case; text value is returned)
removestart(123456123, 123) //Returns '456' (Numbers implicitly converted to text; return value is text)