PrecisionCalc
inspector
text
Do Anything with Text in Formulas

 

itEXTRACT

Retrieves desired characters from text.

 

Syntax

itEXTRACT(text,extract_list...)

text Required. The number or text from which to extract desired characters and/or digits.

text does not appear in Microsoft Excel's 'Insert Function' dialog. Instead, the first extract_list argument is considered the text argument. If the first extract_list argument is a range of cells, then the upper-left cell is considered the text argument.

extract_list... Optional. The list of characters and/or text strings to exclude from text. Accepts up to 29 extract_list arguments.

 

Examples

Formula Description Result
=itEXTRACT("122abc3334444","1","2","3") Extract "1", "2", and "3" from "122abc3334444" 122333
=itEXTRACT("abaabbaaa","b") Extract all occurrences of "b" from "abaabbaaa" bbb
=itEXTRACT("abaabbaaa","bb") Extract all occurrences of "bb" from "abaabbaaa" bb
=itEXTRACT(A1:B2)
 
  A B
1 12abc3 2
2 1 3
Extract 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 123
=itEXTRACT(B2,A1:C3)
 
  A B
1 1  
2 2 12abc3
3 3  
Extract values in cells A1:A3 from value in cell B2 123

See Also

itEXCLUDE
itEXCLUDENOTNUM
itEXTRACTNUM

 

 

PrecisionCalc Home Page