does anyone have a formula/function to extract numbers from alphanumeric
strings?
the numeric portion of the string may contain both leading and trailing "0"s
as well as "-"s; (spaces would not be part of the numeric portion, however
they may occur in the string)

ex: "abc05-0730 def" should return: 05-0730

(there's something in Microsoft online, but it doesn't handle trailing 0's
and seems to have other issues with "certain" string combinations... UGH!)

thanks in advance,
mark