Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.

This function determines if one word (or string of text) can be found in a second piece of text. The function returns a number indicating the position in the string—the characters in the second string are counted and the number indicates the character where the first piece of text begins its overlap in the second string of text. If there are multiple overlaps, FIND only indicates the position of the first match—not any successive matches in the pair.


Example 3: FIND("dog", "The quick sly fox jumped over the lazy brown dog laying next to the other dog.", 47) would would return a value of 75 because the third argument value of 47pushes the start of the search past character 46 (where the first “dog” occurs) and forces the function to find the second “dog” in the string.