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!!!

Homes for 165.99 in town

nco financial Group Inc 77.43

Department, Inc. 113.60 ok

ncetonOne207.49San jose

d M655.72ellon hop[e

ve Boro Realty corp 97.77

ton's449.78 floats

46.27 road

<colgroup><col><col span="2"></colgroup><tbody>
</tbody>

 

[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.