title: Exclude inner tag html using XPATH
body: <p>I have a HTML</p>
  <pre><code>......&lt;div class=&quot;p_value&quot;&gt;Resale
      &lt;a href=&quot;https://www.magicbricks.com/propertyservices/legal-services?inc=pdp_verify_buy_web&quot; target=&quot;_blank&quot; style=&quot;color: #d8232a; display: block;&quot;&gt;Get Documents Verified&lt;/a&gt;
  &lt;/div&gt;....
  </code></pre>
  <p>The expected output: <code>Resale</code></p>
  <p>My incorrect output: <code>Resale    Get Documents Verified</code></p>
  <p>My formula: <code>=IMPORTXML(A2,&quot;//*[normalize-space(text()) = 'Transaction type']/following-sibling::div&quot;)</code></p>
  <p>How do I exclude</p>