Sunday, February 20, 2011

Excel Find Formula

In Excel, the Find function returns the location of a substring in a string. The search is case-sensitive.
The syntax for the Find function is:Find( text1, text2, start_position )
text1 is the substring to search for in text2.
text2 is the string to search.
start_position is the position in text2 where the search will start. The first position is 1.
If the Find function does not find a match, it will return a #VALUE! error.

Applies To:
Excel 2007, Excel 2003, Excel XP, Excel 2000

For example:
Let's take a look at an example:

A1 = Alphabet
A2 = alphabet
A3 = Tech on the Net
Based on the Excel spreadsheet above:
=Find("Alpha", A1, 1) would return 1
=Find("alpha", A1, 1) would return #VALUE!
=Find("alpha", A2, 1) would return 1
=Find("the", A3, 3) would return 9
=Find("ph", "Alphabet", 2) would return 3

Stumble This Fav This With Technorati Add To Digg This Add To Reddit Add To Facebook Add To Yahoo


Post a Comment

Related Posts Plugin for WordPress, Blogger...


Twitter Delicious Facebook Digg Stumbleupon Favorites