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)
|
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)
|
Extract values in cells A1:A3 from value in cell B2 | 123 |
See Also
itEXCLUDE
itEXCLUDENOTNUM
itEXTRACTNUM