Function Find()

Find()

This function searches for a text string within a text string, but this function is case sensitive. This function considers 'Apple' and 'apple' as different text strings. This function returns the position at which the text string is located. And, if the string is not found, it retuns the error (#Value!)

Syntax:

= Find (Search_text, Base_text, Start_pos)

Search_text = Text string which is to be found in the Base Text

Base_text = Text string within which the Search Text is to be found

Start_pos = position in the Base Text from which the function should start looking for the Search Text. This is input is optional

Examples:

• = Find ("e", "Excel Matic") - result will be - 4
• = Find ("E", "Excel Matic") - result will be - 1
• = Find ("c", "Excel Matic") - result will be - 3
• = Find ("c", "Excel Matic",5) - result will be - 11
• = Find ("S", "Excel Matic") - result will be - #Value!

Share on Facebook Share on Twitter Share on Google Plus

About Dhakkanz

This is a short description in the author block about the author. You edit it by entering text in the "Biographical Info" field in the user admin panel.