Excel formula, find the first instance of OU= in string and remove any characters before it

Question

Hi all,

I have 1000's of strings similar to "CN=Joe Smith,OU=Students,DC=Domain,DC=Edu" and I want to find the first instance of OU= and remove the characters before it leaving me with "OU=Students,DC=Domain,DC=Edu". How can I do this with an Excel formula?

Many thanks Jamie

Answer 1

=RIGHT(A1,LEN(A1)-FIND("OU=",A1)+1)