FIND

  • Buffer
  • Sharebar
  • Buffer
jethro's picture

Excel function of the week - FIND and SEARCH

This week we will look at some text functions. FIND and SEARCH are essentially the same function with only minor differences.

magnifying-glass-778751

These functions both allow you to search through a text string (think sentence or word or phrase) in a cell and return the number of the starting character. So when cell A1 has The quick brown fox, =FIND(“fox”,A1) would return 17.

The following screenshots indicate the function arguments and explain the functions syntax.