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.
Recent comments
8 years 39 weeks ago
8 years 39 weeks ago
8 years 40 weeks ago
8 years 41 weeks ago
8 years 41 weeks ago
8 years 41 weeks ago
8 years 41 weeks ago
8 years 41 weeks ago
8 years 41 weeks ago
8 years 41 weeks ago