Pulling Data from a note field in excel [Closed]


I wrote a formula to look through a note text field for a certain phrase and pull a YES. What I need to do is actually pull whatever number is to the right of the text that I am searching for: Example

I am searching for the "*black dog is*" and then I need to pull the number to the right.

the black dog is 70lb
the white dog is 0 lb
the black dog is 200 lb

Thank You!

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!