Find in a string/cell

[Weldon Riker]

Good day!!

=MID(G2,IFERROR(FIND("LI",G2),LEN(G2)-6),7) works beautifully, BUT I also need to find "DP" in that string and return its associated 7 characters. . .

 

[oldchippy]

Hi,

Can you post a sample so that someone can help you find"DP" and its associated 7 characters?

http://chandoo.org/forum/threads/posting-a-sample-workbook.451/#post-73705

 

[Xiq]

Hi Weldon Riker,

Is this an option?

=MID(G2,IFERROR(IFERROR(FIND("LI",G2),FIND("DP",G2)),LEN(G2)-6),7)

 

[Weldon Riker]

Hi Weldon Riker,

Is this an option?

=MID(G2,IFERROR(IFERROR(FIND("LI",G2),FIND("DP",G2)),LEN(G2)-6),7)

That did it!!!
Thank you so very much!