Link to home
Create AccountLog in
Avatar of Steve_Brady
Steve_BradyFlag for United States of America

asked on

Difference(s) between =FIND() and =SEARCH() in Excel

Hello,

In Excel (2007), can someone describe the basic difference(s) between the following two functions and give an example for when each would be the better option?  The two functions are:

   =FIND()    Syntax:  FIND(find_text,within_text,start_num)

    =SEARCH()    Syntax:  SEARCH(find_text,within_text,[start_num])


Thanks
ASKER CERTIFIED SOLUTION
Avatar of SiddharthRout
SiddharthRout
Flag of India image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of Steve_Brady

ASKER

Thanks for the responses.

So as a summary (for future reference), there are two differences:

    1)  =FIND() is case sensitive and =SEARCH() is not.
    2)  =SEARCH() can include wildcards but =FIND() cannot.

Take-home message is:

   Always use =SEARCH() except when case-sensitivity is needed.
Absolutely :)

Sid
good
LOL

You must have seen that within seconds of when I posted it!
Yes :)

Sid

ps: I again did ;)
I literally submitted my response, awarded points and typed "good" and your comment was there.  Couldn't have been more than 20 seconds!
Yeah I know.... :|
You must have some kin of ultra-fast-supercharged-turbo notification system!  LOL  Impressive!
lolzzz. You take care ;)

Sid