Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Functions > Text > FIND
 

FIND(find_text, within_text [,start_num])

 
 Returns the position of a substring within a larger text string.

 find_textThe text you want to find.
 within_textThe text containing the text you want to find.
 start_numThe character at which to start the search.

 REMARKS
 
  		• This function is case sensitive. For a non-case sensitive search, use the SEARCH() function.
     
  		• If "find_text" does not appear in "within_text", then #VALUE! is returned.
     
  		• If "start_num" > the length of "within_text", then #VALUE! is returned.
     
  		• If "start_num" < 0, then #VALUE! is returned.
     
  		• If "start_num" is left blank, then 1 is used.
     
  		• Any blank spaces or punctuation marks count as individual characters.
     
  		• There is also a FINDB() function which can be used with languages that a double-byte character set.

     EXAMPLES
     
     A
    1=FIND("M","Miriam McGovern") = 1
    2=FIND("m","Miriam McGovern") = 6
    3=FIND("A","AAAAAAA",3) = 3
    4=FIND("%","1 3%$%456") = 10
    5=FIND(4,"1 2 3 4 5 6") = 7
    6=FIND("middle","start middle end",1) = 7
    7=FIND("B","AAAAAA") = #VALUE!
    8=FIND("A","AAAA",20) = #VALUE!
    		 
     Functions - F | Index - F | Text Manipulation | Office Online 

     Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top