How to find a specific text (word) within a column character - nominal data type ?
Hi, I'd like to get some help on finding a specific string (actually 2 strings, say "JMP1" and "JMP2") that may be within a column with text, as we move down that column, and then have a formula column next to it to label "JMP1" or "JMP2", if it finds it, or label say "NA" otherwise. A couple of notes:1- "JMP1" or "JMP2" can be in any position within the text in Column 12- "JMP1" and "JMP2" are n...
vince_faller