Can some explain this formula. I know what it does, I just want to understand why

[Jarodjp42]

=LOOKUP(10^9,--MID(J43,MIN(FIND({0,1,2,3,4,5,6,7,8,9},J43&"0123456789")),{1,2,3,4,5,6,7,8}))

Here is the formula, I am confused about the 10^9 and the -- that are listed in the formula. Can someone break it down and explain the meaning behind the inputs please?
Thank you!!!

[TABLE="width: 224"]
<colgroup><col><col span="2"></colgroup><tbody>[TR]
[TD="colspan: 3"]Homes for 165.99 in town[/TD]
[/TR]
[TR]
[TD="colspan: 3"]nco financial Group Inc 77.43[/TD]
[/TR]
[TR]
[TD="colspan: 3"]Department, Inc. 113.60 ok[/TD]
[/TR]
[TR]
[TD="colspan: 3"]ncetonOne207.49San jose[/TD]
[/TR]
[TR]
[TD="colspan: 3"]d M655.72ellon hop[e[/TD]
[/TR]
[TR]
[TD="colspan: 3"]ve Boro Realty corp 97.77[/TD]
[/TR]
[TR]
[TD="colspan: 3"]ton's449.78 floats [/TD]
[/TR]
[TR]
[TD="colspan: 3"]46.27 road[/TD]
[/TR]
</tbody>[/TABLE]

 

[Aladin Akyurek]

Thank you for your response @ Aladin Akyurek. I'm curious into why you avoid using the IFERROR function at all costs. I feel like it could be useful in certain scenarios, but then again I'm not an expert of excel. If you could share your thoughts I would love to learn more about it.

I already said that it is costly (time consuming) function. Whenever it can be avoided, it should be avoided.