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")
Bookmarks