Category: Text function

This function removes the individual characters specified in chars from text.

Return value type: Text

The individual characters listed in chars are removed from text, not just the whole value of chars as a string.

All instances of each character in chars are removed.

If none of the characters in chars appear in text, the whole value of text is returned.

removechars('Jayne Mansfield', 'aeiou') //Returns 'Jayn Mnsfld'

removechars('Jane Goodall', 'al') //Returns 'Jne Good'

removechars('Jane Seymour','clk') //Returns 'Jane Seymour'

removechars(102102102,12) //Returns '000'  (Numbers are implicitly converted to text; value is returned as text)

• Remove(text, start, length)
• RemoveEnd(text, length)
• RemoveStart(text, length)
• RemoveText(text, string)