Excel Formula Extract any number greater than x charters from a string

Question

I have a file with a list of data in it. Each cell has a name, a number, and a date, which is either in the format mm/yy, mm-yy, mm-yyyy, etc. (just the month and year, never the day) The quantity I require will never be less than five characters. Is it possible for me to extract just the number from the string?

• xx company holding - 96923432 -02-22. (number required 96923432)
• yy Company (HOLDINGS) LTD - 131002204 - 02/2023 (number required 131002204)
• ab HOLDINGS LIMITED / 115472907 / Feb-23 (number required 115472907)

Answer 1

Given that you employ two separate delimiters, this is intriguing. But don't worry, you can easily use the next method to record both instances. Simply add additional delimiters between the the textbefore and textafter functions if you have any available. A sample of the equation is shown below.

=TEXTBEFORE(TEXTAFTER(A2, {"-","/"}), {"-","/"})

This should work for you then if you want to return nothing if output is less than 5.

 =IF(LEN(TEXTBEFORE(TEXTAFTER(A1,{"-","/"}),{"-","/"}))>5,TEXTBEFORE(TEXTAFTER(A1,{"-","/"}),{"-","/"}),"")