Apostrophe Issue with Character Count

    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


    =LEFT(A1,7)


    If I enter the following formula in cell C1, it yields: Yes


    =IF(LEFT(A1,5)="Raley","Yes","No")


    But, if I change the formula in cell C1 (apostrophe added, 5 changed to 7), it yields: No


    =IF(LEFT(A1,7)="Raley’s","Yes","No")


    So an apostrophe is recognized by Excel in the cell B1 formula, but not in the cell C1 formula. What am I overlooking?

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login