Thread: Search Function Problem
View Single Post
 
Old 06-29-2011, 08:27 AM
Kimberly Kimberly is offline Windows 7 64bit Office 2010 64bit
Expert
  
Join Date: May 2010
Posts: 517
Kimberly is on a distinguished road
Default
No, the result should not be 1.

=SEARCH("fire","fireman") should be 1.

The frist argument is what you want Excel to find. The second argument is where you want Excel to look. There is no "fireman" in "fire".
Reply With Quote