I'm having trouble with a formula looking for a "word" but in some cells it has "word another word"
<tbody>
</tbody>
So i'm using a formula that is looking for "FLB". But because some cells have "FLB CTW", it skips these and only uses the cells that have "FLB" only. How do i write the formula to include "FLB" even if it has another word in the cell?
A | B | |
1 | FLB | Name |
2 | FLB CTW | Name |
3 | CTW | Name |
4 | FRF | Name |
5 | 2RF FRF | Name |
<tbody>
</tbody>
So i'm using a formula that is looking for "FLB". But because some cells have "FLB CTW", it skips these and only uses the cells that have "FLB" only. How do i write the formula to include "FLB" even if it has another word in the cell?