Extracting Number String from Long Text/Number String

[Garmerr]

Hello Everyone,
Long time lurker, first time poster.

I am interested in pulling an 8 to 10 digit number string from a cell populated with text and numbers. The number string will change in content and location. The preceding characters will also change between numbers and letters.

Examples:
1) Austria - Wien - Kirchengasse -08202-820263712-LABOR VERBRAUCHSSTOFFE UND AUSRÜSTUNG (590, 610)-82925-001
In example (1) I want to pull out the string "820263712"

2) Austria - Wien - Lange Allee 24 -08202-820262511-LABOR CHEMIKALIEN UND BIOLOGISCHE WIRKSTOFFE (600)-82921-001
In example (2), I want to pull out the string "820262511".

3) 07390-07390-Non-Capital-739070611-POL-?WIADCZENIA – OGÓLNE-82180-ALL
In example (3), I want pull out the string "739070611"

4) United States - Los Angeles CA (BAX)-07001-7001200168-AIDLAPPP-COGS240-MAINTENANCE AND REPAIR SERVICES: OTHER-84789
in example (4), I want to pull out the string "7001200168"

5) 07140-71400637-TRANSPORTE / ENVÍO (339, 947)-83148
in example (5), I want to pull the string "71400637"

Any ideas? Thanks for your time.

 

[oldbrewer]

because the string can vary both in length and location, and there are other numerical strings surrounded by dashes eg -08202- you cannot do this without supplying some intelligence, probably in the form of extracting all numerical strings then manually choosing one of them