Find Function
This function returns the position of the supplied character or part of text from the selected text string. This is case sensitive.
Syntax: FIND(find_text,within_text,[start_num])
Example: =FIND("d","India",1)
Result: 3 ("d" position in "India" is 3)
Assignments:
1. Find the position of ":" from "Time:is money"
2. Find the position of " "(space) from "Dare Devil"
3. Find the position of "$" from "Exc$l"
This function returns the position of the supplied character or part of text from the selected text string. This is case sensitive.
Syntax: FIND(find_text,within_text,[start_num])
Example: =FIND("d","India",1)
Result: 3 ("d" position in "India" is 3)
Assignments:1. Find the position of ":" from "Time:is money"
2. Find the position of " "(space) from "Dare Devil"
3. Find the position of "$" from "Exc$l"
No comments:
Post a Comment