Regular Expression Pattern

[goss]

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.

[Ron Coderre]

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?

[JosephP]

perhaps

Please Login or Register  to view this content.

[goss]

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.