• 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.


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.