I couldn't get these formulas to work:
<tbody>
</tbody>
Data starting in A4:
<tbody>
</tbody>
I would like a formula that would return
0104-8
0104-9
0107
Any idea what I am doing wrong?
=MIN(FIND({0,1,2,3,4,5,6,7,8,9},A4&"0123456789")) | ||||
=MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A5&"0123456789")) | ||||
=RIGHT(A6,SUM(LEN(A6)-LEN(SUBSTITUE(A6,{"0","1","2","3","4","5","6","7","8","9"},"")))) |
<tbody>
</tbody>
Data starting in A4:
Agnes Twp, Fordville SD, Niag Fire - 0104-8 |
Agnes Twp, Fordville SD, Ink Fire - 0104-09 |
Agnes Twp, Larimore SD - 0107 |
<tbody>
</tbody>
I would like a formula that would return
0104-8
0104-9
0107
Any idea what I am doing wrong?