Find a word in macro

Closed
Ezhil - 13 May 2010 à 02:18
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 13 May 2010 à 07:39
Dear All,

I have a excel sheet, it contains 100 rows value, now I need to find which are the rows has the word "apple", if it has it should return true or false...

anyone can help me on this. please.........
Related:

1 response

rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
13 May 2010 à 07:39
To me at least, your question seem rather ambigious

How ever one way is

=IF(ISERROR(FIND("apple", A1,1)),"No Apple","Yes Apple")

IF this is not what you seek, then could you please upload a sample file with sample data etc on some shared site like https://authentification.site , http://wikisend.com/ etc and post back here the link to allow better understanding of how it is now and how you foresee.