PrecisionCalc
inspector
text
Do Anything with Text in Formulas

itEXCLUDE

Excludes undesired characters and strings from text.

Syntax

itEXCLUDE(text,exclude_list...)

 text Required. The text from which to exclude characters. The text argument does not appear in Microsoft Excel's 'Insert Function' dialog. Instead, the first exclude_list argument is considered the text argument. If the first exclude_list argument is a range of cells, then the upper-left cell is considered the text argument. exclude_list... Optional. The list of characters and/or text strings to exclude from text. Accepts up to 29 exclude_list arguments.

Examples

Formula Description Result
=itEXCLUDE("12abc34","abc") Exclude "abc" from "12abc34" 1234
=itEXCLUDE("1a2b.c3def4","c","e","b","d","a","f") Exclude "c", "e", "b", "d", "a" and "f" from "1a2b.c3def4" 12.34
=itEXCLUDE("abaabbaaa","a") Exclude all occurrences of "a" from "abaabbaaa" bbb
=itEXCLUDE("abaabbaaa","aa") Exclude all occurrences of "aa" from "abaabbaaa" abbba
=itEXCLUDE("123","2") Exclude "2" from "123" 13
=itEXCLUDE(A1:B2)

 A B 1 12abc34 b 2 a c
Exclude values in cells A1:B2 (except A1, because the first argument is a range and A1 is the upper-left corner of the range) from the value in cell A1 1234
=itEXCLUDE(B2,A1:C3)

 A B 1 a 2 b 12abc34 3 c
Exclude values in cells A1:A3 from value in cell B2 1234