Extract string from a link

Hi everyone,

I have this information which is big load of code and i need to extract only the part in green which will always be anticipated by <p> and followed by </p>

Anyway i can achieve this? see the attachments!

thank you all!


=MID(A9,SEARCH("<p>",A9)+3,SEARCH("</p>",A9)-SEARCH("<p>",A9)-3)

I thought of using something like this but it does give me some blank space both at the beginning and at the end...