How do you extract text from the middle of another text field?

I need to extract a person?s name from another field that captures the date and person that made the change.  I am struggling with a formula that captures the characters between the second blank an...