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