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)
|
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)
|
Exclude values in cells A1:A3 from value in cell B2 | 1234 |
See Also
itEXCLUDENOTNUM
itEXTRACT
itEXTRACTNUM