Hi,
I need to write a formula that looks for the first two characters in a string of text and returns a value in a column next to that text.
I.e., if column D contains AA at the beginning of the text string, return a "yes" in column C, if no AA, return a "no" in column C. Is this possible?
Bookmarks