title: How do I remove duplicate content within a sigle excel cell
body: <p>I have individual cells in excel with the following content in each of them</p>
  
  <pre><code>http://www.teng.mossdemo.com.au/wp-content/uploads/images/products/m1423.jpg|http://www.teng.mossdemo.com.au/wp-content/uploads/images/products/m1423.jpg
  
  http://www.teng.mossdemo.com.au/wp-content/uploads/images/products/rt2899.jpg|http://www.teng.mossdemo.com.au/wp-content/uploads/images/products/rt2899.jpg
  </code></pre>
  
  <p>This is one cell in a long row for a dump of data for products within an ecommerce site. A data migration has somehow added the same image more than once to the same product. Each separate image image is separated by the Pipe "|" symbol.</p>
  
  <p>I want to search each cell in this column of the sheet and remove the duplicated image reference and the Pipe symbol.</p>
  
  <p>So the examples above become</p>
  
  <pre><code>http://www.teng.mossdemo.com.au/wp-content/uploads/images/products/m1423.jpg
  </code></pre>
  
  <p>and</p>
  
  <pre><code>http://www.teng.mossdemo.com.au/wp-content/uploads/images/products/rt2899.jpg
  </code></pre>