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

See Also

itEXCLUDENOTNUM
itEXTRACT
itEXTRACTNUM

 

PrecisionCalc Home Page