Searching for partial, but only when it's its own word

[oscark37]

Let's say T12 = 'Novice Dec

=IF(ISNUMBER(SEARCH("nov",T12)),"5",IF(ISNUMBER(SEARCH("dec",T12)),"6",""))

With the above equation, it will return "5". I want it only to return "5" if "nov" is its own word. IE in this case, it want it to return "6".

Thanks for the help.

Oscar

 

[Marcelo Branco]

Try

=IF(ISNUMBER(SEARCH( " "&"nov"&" "," "&T12&" ")),"5",IF(ISNUMBER(SEARCH( " "&"dec"&" "," "&T12&" ")),"6",""))

M.

 

[Rick Rothstein]

Let's say T12 = 'Novice Dec

=IF(ISNUMBER(SEARCH("nov",T12)),"5",IF(ISNUMBER(SEARCH("dec",T12)),"6",""))

With the above equation, it will return "5". I want it only to return "5" if "nov" is its own word. IE in this case, it want it to return "6".

Will the cells you are searching (such as T12 in your example above) ever contain punctuation (commas, periods, dashes, parentheses, etc.) next to the words you search for or will those words always have a space next to them on either side (unless, of course, they are the first or last word in which case there would only be a space on one side of them)?