Return Text Between TGP>

[dparteka]

In Sheet1!A1 is the following text… TO BEGINNING AND END OF SEAL STRIP TGP>OD Micrometer<TGP 060.


In Sheet2!A1 I want the text that is between TGP> and <TGP to appear here.


The text string before, after and in between the TGP> and <TGP will always vary in length.

 

[Marc L]

(No salutation as well ‼)

=MID(Sheet1!A1,FIND("TGP>",Sheet1!A1)+1,FIND("<TGP",Sheet1!A1)-FIND("TGP>",Sheet1!A1)-1)

 

[dparteka]

Hello there Marc L... you are a wizard, works great, thank you so much

 

[Marc L]

Hummm,   seems "Big Brother" was there …