Help with formula to return the word before third Comma in a string

Dear All

I was wondering whther I can help with the formula which achive te follwoing
I need to extract the follwoing: Stating from the right to return the word before the 3 Comma in follwong example "Staff" , however it snot alway Staff it coud be Library or Studnet

U=IT Services,OU=IIII,OU=Staff,DC=xxx,DC=xx,DC=xxxxx

Any help is appreciate it

Dear Special-K

Thanks for this, It is only going to be those combinations but onle the text before the 3 comma in the string after OU=

Maybe like this?

=TRIM(MID(SUBSTITUTE(SUBSTITUTE(A1,"=",","),",",REPT(" ",200)),1000,200))

Thak you for tis, but apologies from me , I need the text before the third comma because the format is not always the same i.e. I have something like
N=Library,DC=xxx,DC=xx,DC=xxx

which means starting from the right return the text before the third comma until it hits the = sign so in the case above it will be Library but in forst example it will be Staff

Dear AlKey

This is great but I need it to return the value Staff in the first case and Users in the second example as the formula you have given me returns th whole string

Just to clarify as I think I ma causing a bit of a confusion
in the first example
U=IT Services,OU=IIII,OU=Staff,DC=xxx,DC=xx,DC=xxxxx
starting from the right to look at the word before the third comma which is Staff and return value Staff
and in the example
N=Library,DC=xxx,DC=xx,DC=xxx
starting from the right look at the word before the third comma and return its value which is Library

Its always the word immediately before the third comma (starting from the right) after the =

Try again

=TRIM(LEFT(RIGHT(SUBSTITUTE(SUBSTITUTE(A1,"=",","),",",REPT(" ",200)),1400),200))

Dear Phuocam

Worked perfectly. Thank you so much for your help