FIND Fucntion in excel finds the location of the character in the given srtring. FIND Function is case-sensitive.
find_text:the text or the character you want to find
within_text: the string in whichy you want to find a specific character
start_num: it is a optional. It is a starting point from where you want to find a specific character
We have use an example of "Pineapple"
The find function will return the specific number on which a character is.
FIND P : It will return you 1 because P is at the begaining of the string
FIND e : It will return you 4 because e is at the fourth locatuion of the string
FIND l : It will return you 8 because l is at the eightth location of the string
Syntax of FIND Fucntion
= FIND(find_text,within_text,[start_num])
Arguments of FIND Fucntion
find_text:the text or the character you want to find
within_text: the string in whichy you want to find a specific character
start_num: it is a optional. It is a starting point from where you want to find a specific character
Behaviour of FIND Function
A shown in the aboveWe have use an example of "Pineapple"
The find function will return the specific number on which a character is.
FIND P : It will return you 1 because P is at the begaining of the string
FIND e : It will return you 4 because e is at the fourth locatuion of the string
FIND l : It will return you 8 because l is at the eightth location of the string
Use of FIND Fucntion
To find the location of the specific characterReturn of FIND Fucntion
FIND Function return the location of the character from the stringNote 1:
If there are no specific character you want in the string the FIND function will give #VALUE Error
No comments:
Post a Comment