Table of Contents

RemoveText(text, string)

Category: Text function


Description

This function removes all instances of string from text.


Arguments

ArgumentTypeDescription
textTextAny text value from which the text string is removed.
stringTextThe text string removed from text.

Return value type: Text


Remarks

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.


Examples

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)


See also