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

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"

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

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.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional

thanks for the response. i tried but failed .in the find and replace optionsi 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.

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

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.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional

Perhaps you have leading or trailing spaces?
yes you are right.it seems that there is space after the word event.