how can i ask excel to find "Event" AND NOT "Eventdate"

[sumesh56]

i have some rows with the word Event. in some rows I have the wor
Eventdate. now i want to find out all the rows with the word event,ho
can i make excel to find the rows which contain the word " "Event" AN
NOT "Eventdate

 

[Claus Busch]

Hi,

Am Fri, 18 Apr 2014 08:12:08 +0100 schrieb sumesh56:

i have some rows with the word Event. in some rows I have the word
Eventdate. now i want to find out all the rows with the word event,how
can i make excel to find the rows which contain the word " "Event" AND
NOT "Eventdate"

in Find & Replace dialog click Options and activate "Whole cell"


Regards
Claus B.

 

[sumesh56]

Hi,

Am Fri, 18 Apr 2014 08:12:08 +0100 schrieb sumesh56:
-

in Find & Replace dialog click Options and activate "Whole cell"


Regards
Claus B.

thanks for the response. i tried but failed .in the find and replac
options>i have tow options
match case
match entire cell contents
i have checked the second one and got error message which said
microsoft excel cannot find the data you are searching for

 

[Claus Busch]

Hi,

Am Fri, 18 Apr 2014 12:42:34 +0100 schrieb sumesh56:

match entire cell contents

yes, that is the correct name for the option.

i have checked the second one and got error message which said
microsoft excel cannot find the data you are searching for.

Perhaps you have leading or trailing spaces?


Regards
Claus B.

 

[sumesh56]

Hi,

Am Fri, 18 Apr 2014 12:42:34 +0100 schrieb sumesh56:
-

yes, that is the correct name for the option.
-

Perhaps you have leading or trailing spaces?


Regards
Claus B.

Perhaps you have leading or trailing spaces?
i really don't know how to check it