Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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"
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
|
|||
|
|||
Quote:
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
|
|||
|
|||
Quote:
yes you are right.it seems that there is space after the word event. Last edited by sumesh56 : April 18th 14 at 06:02 PM |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel |