Excel formula to extract numbers from text

[Lee733]

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?

 

[Rick Rothstein]

I tried changing to a semi-colon, and that did not work.

Even for the formula I posted?

=TRIM(RIGHT(SUBSTITUTE(A4;" ";REPT(" ";200));200))

What error did you get when you tried this?

 

[Lee733]

https://www.dropbox.com/s/xpjh0rgp6u70x3t/Screenshot 2018-01-23 14.01.09.png?dl=0

I am hoping you can see the error on the attached link. Let me know.

 

[Aladin Akyurek]

https://www.dropbox.com/s/xpjh0rgp6u70x3t/Screenshot 2018-01-23 14.01.09.png?dl=0

I am hoping you can see the error on the attached link. Let me know.

Instead of an image, you should put up the workbook itself.

 

[Lee733]

https://www.dropbox.com/s/mawdl022kmj37ni/Screenshot 2018-01-23 14.19.20.png?dl=0

 

[Rick Rothstein]

https://www.dropbox.com/s/mawdl022kmj37ni/Screenshot 2018-01-23 14.19.20.png?dl=0

You posted a copy of the picture... Aladin asked you to post your actual workbook that contains your actual data.

 

[Lee733]

I guess I do not know how to do that.

 

[Aladin Akyurek]

I guess I do not know how to do that.

Post a shared link to the workbook file that you have. That file must be uploaded to the dropbox. Once that is done, you can share a link to that file.

 

[Lee733]

https://www.dropbox.com/s/1z6nnvuvnm4lt5p/FORMULAS I HAVE TRIED.xlsx?dl=0

Is this correct?

 

[Aladin Akyurek]

https://www.dropbox.com/s/1z6nnvuvnm4lt5p/FORMULAS I HAVE TRIED.xlsx?dl=0

Is this correct?

See: https://www.dropbox.com/s/hb8u6lcq60mxu9s/FORMULAS I HAVE TRIED.xlsx?dl=0

 

[Lee733]

Thank you for all your help. You and Rick are amazing! Debbie