Find
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.
Note:
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
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.
Note:
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
Source: www.excel-functions.blogspot.com
0 comments:
Post a Comment