Hello All
I receive an excel file where a cell would contain a series of acronyms separated by a comma.
Is there a formula that will return a result if a portion of a cell equals the query, or will I just have to stick with text to columns and then an if(or statement.
Example:
<tbody>
</tbody>iF A1 CONTAINS "CNS' RETURN A VALUE OF "Y"
I would appreciate any assistance
Russ
I receive an excel file where a cell would contain a series of acronyms separated by a comma.
Is there a formula that will return a result if a portion of a cell equals the query, or will I just have to stick with text to columns and then an if(or statement.
Example:
A | B | C | |
1 | AB,CNS,RDSH,BTBC | ||
2 | |||
3 |
<tbody>
</tbody>
I would appreciate any assistance
Russ