View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.misc
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default How to search for text?

On Wed, 19 Mar 2008 22:01:01 -0700, Eric
wrote:

I have tried the function search and find, both functions are working when
the source file is closed, but it seems to me that both do not work for fuzzy
matching.
Does anyone have any suggestions?


If by "fuzzy matching" you mean matching "apple" when it exists anyplace within
the string, my suggestion is that you read about and try out the SEARCH and
FIND functions. Be sure in your reading to consider the slight difference
between the two.
--ron