Description: Returns the start position of the StringSought
in StringSearched starting in position Start.
Start : Optional. Index of the character in StringSearched to start the
searching for StringSought StringSearched : Optional. String to be
searched for the string StringSought StringSought : Optional. String to
be sought in string StringSearched Compare : Optional. Constant to
denote the method of searching: 0 (default) denotes binary compare (Case
sensitive) and 1 denotes a text compare.
Example:
Find the position of the Word
world in hello world (=0: cannot be found) =InStr(1,"hello
world","World") Find the position of the word World in hello
world with a text search (case sensitive)
=InStr(1,"hello
world","World",1)
Copyright (C) 1995-2007 Linker IT
Software BV. All Rights Reserved. Oracle is a registered trademark of
Oracle corporation. Excel and Office are registered trademarks of
Microsoft corporation. Other names appearing on the site may be trademarks
of their respective owners. Software,
files, documents, articles and other material are provided
"as is" and without warranties as to performance or mechantability or
any other warranties whether expressed or implied. No
warranty of fitness for a particular purpose is offered.
sitemap
