Need string within string

[djl0525]

From this string in F5,
CN=Donald Duck/OU=ABC/O=DEFGH/C=US

I need the name, Donald Duck.

All strings begin with the same 3 characters, CN=
All strings have "/" after the name followed by any number of characters


Your help will be greatly appreciated. -- DJ

 

[Banker1]

Try this

=MID(F5,(FIND("=",F5,1)+1),((FIND("/",F5,1)-1)-FIND("=",F5,1)))

 

[djl0525]

That worked great! Thanks!

I just discovered that not all strings begin with CN=.
Can you modify the formula so that if the string begins with CN= it does this...

=MID(F5,(FIND("=",F5,1)+1),((FIND("/",F5,1)-1)-FIND("=",F5,1)))


If not, F5.

Thank you in advance for your consideration -- DJ

 

[Smitty]

Just add a test:

=If(left(f5,2)="CN",MID(F5,(FIND("=",F5,1)+1),((FIND("/",F5,1)-1)-FIND("=",F5,1))),f5)

HTH,

 

[djl0525]

Perfect!

Thank you Banker1 and Smitty!

-- DJ

 

[Scott Huish]

=if(left(f5,3)="cn=",mid(f5,4,find("/",f5&"/")-4),f5)