Regular Expression Pattern

Hi all,

Using Excel 2010, 2013.

What would be the correct regular expression pattern to extract this substring : 234-456-00000000-45-234 from a string like

mnasdf 234 234-456-00000000-45-234 sdf 123 34

The string will vary, the substring does not vary other than the digits can be any number 0-9
I need to retain the hyphens "-" as well

I tried patterns like

Please Login or Register  to view this content.

But not working

Thx
w

Please Login or Register  to view this content.

EDITED TO USE JosephP's pattern (which is more concise)
Try this

Please Login or Register  to view this content.

Applied this way...
A1: mnasdf 234 234-456-00000000-45-234 sdf 123 34
B1: =findpattern(A1)

In that example, the function returns: 234-456-00000000-45-234

Is that something you can work with?

perhaps

Please Login or Register  to view this content.

Ron , JosephP -

Thanks for your help
I combined with some help I received earlier from shg and using these 2 functions I now have exactly what I need.

Thanks again,
w

Please Login or Register  to view this content.