Excel Magic Trick 520: FIND & SEARCH Functions

Learn about FIND and SEARCH functions: 1.Both functions find the position of a substring in a string the position of some characters within a different set of characters. For example FIND(A,ISAAC) = 3, SEARCH(A,ISAAC) = 3 because the first A is the third character in ISAAC. 2.FIND is case sensitive and does not allow wildcards such as * (1 or more characters) or ? a single character. 3.SEARCH is NOT case sensitive and it accepts wildcards. 4.Use LEFT FIND and SERCH to extract first names 5.See how to do Fuzzy Math or Approximate Lookup using LOOKUP, SEARCH, FIND, 2^15



http://www.youtube.com/watch?v=2R2OYJbKHlA&hl=en

Game (FR) Hot Game !!!