Quote:
Originally Posted by 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.
--
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.