using MID function to pull specific characters from text

[zlittle]

I have cells that look something like this:

ab=jenda,ou=par,ou=IP,dm=prinusa,dm=bill,dm=prin

I need to pull the letters IP only. The IP always falls right after an equals sign and before the text string ",dm=prinusa". The characters i need to pull are not always two characters in length (sometimes 3 or 4). There are always several equals signs in each cell before and after the characters I want to pull.

I have tried a combination of MID and SEARCH but can't seem to figure this one out. The many equals signs and the fact that it isn't always two characters long has made my searching hard.

Any help would be appreciated.

Thank you in advance!

 

[Tetra201]

Try this:

=RIGHT(MID(A1,FIND(",dm=prinusa",A1)-5,5),5-FIND("=",MID(A1,FIND(",dm=prinusa",A1)-5,5)))

 

[zlittle]

That worked. I will have to try to make sense of it so I can explain it. Thank you very much!!

 

[Tetra201]

You are welcome.

 

[inactiveuserps07]

zlittle, it looks like you solved this. But if you know the result will always be "IP," why have a formula at all? Why not just enter "IP" in the cell? Just curious ...