There are two similar functions in Excel that allow one to search for the position of a character in a text string. The function are the FIND() and SEARCH() functions. They are so similar till one wonder why have two function that perform identical task? However, there are key differences between the two.
The FIND() function is case sensitive whereas the SEARCH() is not case sensitive The other differences is FIND() function does not accept wildcard character whereas the SEARCH() function does.
Both function can search single character, words and symbol within a sentence or text string.
No comments:
Post a Comment