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.