I am comparing two cells. For example lets say the first cell A1, contains the following: MW tt EC. Lets say the cell I am comparing it with, B1, contains: mw. The upper and lower case have different meanings in my work sheets. I want to do a case sensitive selection, selecting B1 if A1 contains B1. In the example I gave the formula should not select B1 since lower case mw is not contained in A1. "Exact" seems to be used for
differentiating between upper and lower case, but I can't figure out if its use is possible when the cell may contain other characters as well. I would appreciate it if someone could give me a hand with this?