Extract text from one field to another

Hi, is it possible to extract text from one field to another based on a specific word or string?  I have been playing around with the right function but I am not getting the results I need.  As an exa...