Solved by Samir Shaker ( thank you ) Good day How can I search (using a function )for a word within a sentence that is written in a different way every day..
Solved by Samir Shaker ( thank you )
Good day
How can I search (using a function )for a word within a sentence that is written in a different way every day.. For example, the word expo.. is written in different ways
Thanks
Replies
The FIND function is not case sensitive.
Glenn Bamford reverse, FIND is case sensitive.
You actually told the function name in your query, SEARCH function. Assuming that your data started from Cell A2. then you can try the following formula in Celll B2.
=IF(ISNUMBER(SEARCH("Expo",A2),"Listed","Not Listed")
I used IF and ISNUMBER function with SEARCH. If the word 'EXPO' was there, it will generate a number from where the word been started. if there's no number, that means the word 'Expo' is not there. IF used to generate a Outcome if found /not found. in this case, if found, it will generate a word 'LISTED', if not then NOT LISTED.
Nedal AlBasha If Solution which are already provided is perfect the. Ok Otherwise Show Expected Result
