← Back to Text functions

Text.Remove

Eliminates any instances of a specific character or set of characters from a given text value. The removeChars parameter can consist of either a single character or a series of character values.

Syntax

Text.Remove(text as nullable text, removeChars as any) as nullable text

About

Eliminates any instances of a specific character or set of characters from a given text value. The removeChars parameter can consist of either a single character or a series of character values.

Explanation

Eliminate the characters ',' and ';' from the text value using Power Query MText. The function used is MText.Remove("a,b;c", {",",";"}). The output will be "abc".