Code to Extract certain text from a string

Hi All,

I have a string of text and within it is a certain ID that is consistently formatted in the same way, but the location within the text is not always the same.
Format is: 1-XXXXXX

I have created a formula that extracts the ID about the majority of the time, but does anybody know of a way that I could write a code to find 1-XXXXXX within the text string and just extract portion?

This is probably confusing so I've included an example and an excel sheet to show.

Thanks!

Formula currently used:
=IF((LEFT(RIGHT(LEFT($D2,34),8),1)="1"),RIGHT(LEFT($D2,34),8),"N/A")

Hi Bcorm,
try it

Formula:

Please Login or Register  to view this content.

These were exactly what I was looking for, Thank you!