Search numbers in a text string, find largest "value" return a value

Ok,
Real World Explain:
I have searched and searched for a solution. I am dealing with a string of mineral ownership of land output as text from proprietary system. Sections in a township and range are approx 640 acres. The acres that make up a lease are to the direct left of the approx 640 acres, as is the % ownership. I want the acres to the left of the largest value.

Pseudo Code:
Search alphanumeric text field for the largest number (usually around 640), return the value, decimal and all to the left of the slash of the largest value (usually around 640).

Examples:
Fields can vary a lot. And values can be twice 640, cuz maybe you are dealing with two sections, so 1,280 acres.

1/2 x 151.1112/643.9502 x 3/16 answer is 151.1112
1/2 x 5.0033/643.9502 x 1/4 answer is 5.0033
1/2 x 40/100 x 1/2 x 3/640.5661 x 1/4 answer is 3
1/2 x 72.091/1,276.1256 x 1/4 answer is 72.091 (rarely happens, but it does)

First post ever, apologies if I didn't follow any forum rules correctly.

Thank you

OilGasKing,

Welcome to the forum.

Can you please upload a small sample workbook - even one which just includes the information above would be fine - so we can see how your data is laid out ("1/2 x 151.1112/643.9502 x 3/16" could be in one or many cells, for example, and the solution may depend on how your data is arranged.)

Hi,

Attached is your solution. Hope this helps.

Using your first posted workbook, this regular formula pulls the last number before the last slash (/)

Please Login or Register  to view this content.

Copy that formula down as far as you need.

With your sample data, these are the returned values:

Please Login or Register  to view this content.

Is that something you can work with?

@Ron,

My 20 lines of code for just 1 line of yours. Coding and time optimized. That's Great.