automatic split cell text in google sheet
<p>any formula or script to automatic split cell text in google sheet for ex:</p>

<p>i have text in cell A and i want to split text in Cell B </p>

<p>if cell A with this value (<a href="http://example.com/?/http://demo.com" rel="nofollow">http://example.com/?/http://demo.com</a>)  then in cell b i need demo.com automatic ..</p>

<pre><code>         Cell A              ----------------              Cell B

http://example.com/?/http://demo.com                     http://demo.com

http://example.com/?/http://aol.com                      http://aol.com   

http://example.com/?/http://bbc.com                      http://bbc.com
</code></pre>

<p>but also i want that Cell a contain true value . imean i dont want to change cell a value if cell a contain  <code>http://example.com/?/http://demo.com</code>   after split this value remain same in cell A .. </p>

<p>thanks i hope you understand my question ..</p>