SEARCH

Microsoft Datasheet View

Remarks

  • SEARCH does not distinguish between uppercase and lowercase letters when searching text.
  • SEARCH is similar to FIND except that FIND is case sensitive.
  • If find_text is not found, the #VALUE! error value is returned.
  • If start_num is omitted, it is assumed to be 1.
  • If start_num is not greater than 0 (zero) or is greater than the length of within_text, the #VALUE! error value is returned.

Example

Col1Col2Col3Formula Description (Result)
StatementsProfit Marginmargin=SEARCH("e",[Col1],6) Position of the first "e" in the string, starting at the sixth position (7)
StatementsProfit Marginmargin=SEARCH([Col2],[Col3]) Position of "margin" in "Profit Margin" (8)
StatementsProfit Marginmargin=REPLACE([Col3],SEARCH([Col3],[Col2]),6,"Amount") Replaces "Margin" with "Amount" (Profit Amount)