I have a cell (A1) whose contents (formatted as text) = Raley’s Xxxxxx
If I enter the following formula in cell B1, it yields: Raley’s
If I enter the following formula in cell C1, it yields: Yes
But, if I change the formula in cell C1 (apostrophe added, 5 changed to 7), it yields: No
So an apostrophe is recognized by Excel in the cell B1 formula, but not in the cell C1 formula. What am I overlooking?