none
finding the value within a cell? RRS feed

  • Question

  • I have a cell that has the string SUSAN

    I want to know if the third letter is an S

    So in the above example the answer is true, if the value were Mark the answer is false


    Jim

    Thursday, June 25, 2015 5:14 PM

Answers

  • =MID(A1;3;1)="S"

    Returns TRUE or FALSE

    MID(Cell, position, length)

    • Proposed as answer by André Santo Thursday, June 25, 2015 5:40 PM
    • Marked as answer by Seidel1 Thursday, June 25, 2015 8:50 PM
    Thursday, June 25, 2015 5:39 PM

All replies