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 example I would like to extract the data in bold type for each question.  So couldn't you have a formula that would look for "in the appeal:" and give the result "W123456789"?

1) Please enter the ID at the top of your letter in the appeal:

W1234567890


2) On a scale of 1-5 how satisfied are you :


     With the time it took to resolve the appeal once you submitted it to the appeals department: Not at all Satisfied with the time it took     
  
     That you were treated fairly?: Not at all Satisfied that I was treated fairly
  
     That the response you received was clear and easy to understand?: Not at all Satisfied was easy to understand      
  
     With your choices of how to correspond with us about your appeal?: Not at all Satisfied with my choices

------------------------------
John Kelley
------------------------------