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 Google Plus

About Nifty Guru

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.
    Blogger Comment
    Facebook Comment

0 comments:

Post a Comment

Saturday, June 13, 2009

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!

Function Find()SocialTwist Tell-a-Friend

0 comments:

Post a Comment