Sample data set below shows two separate text options within the column if the data has the _ within the cell I need to run a different formula than the ones without a _. And to avoid mistake the _ should only appear in the second character position.
<colgroup><col width="65" style="width:49pt"> </colgroup><tbody>
</tbody>
mustangs |
A_aces |
badgers |
panthers |
bulldogs |
T_aardvarks |
C_Slitheren tigers |
<colgroup><col width="65" style="width:49pt"> </colgroup><tbody>
</tbody>