<p><strong>Problem description &amp; analysis</strong>:</p>
<p>In the following Excel table, cell A1 and cell B1 contain strings made up of vertical line-separated numbers and walled in by vertical lines at both ends:</p>
<div class="hn-table">
<table>
<thead>
<tr>
<td></td><td>A</td><td>B</td></tr>
</thead>
<tbody>
<tr>
<td>1</td><td>｜55｜56｜60｜99｜120｜</td><td>｜55｜56｜62｜100｜121｜130｜210｜312｜</td></tr>
</tbody>
</table>
</div><p>Task: find numbers that exist in A1 but does not exist in B1 and display them in the same format:</p>
<div class="hn-table">
<table>
<thead>
<tr>
<td></td><td>D</td></tr>
</thead>
<tbody>
<tr>
<td>1</td><td>｜60｜99｜120｜</td></tr>
</tbody>
</table>
</div><p><strong>Solution</strong>:</p>
<p>Use <strong><em>SPL XLL</em></strong> to do this:</p>
<pre><code class="lang-plaintext">=spl("=$[|] / (?1.split($[|]) \ ?2.split($[|])).concat($[|])/ $[|]",A1,B1)
</code></pre>
<p>As shown in the picture below:</p>
<p><img src="https://preview.redd.it/find-the-differences-between-contents-of-two-cells-v0-t4rz4uwxuked1.png?width=1053&amp;format=png&amp;auto=webp&amp;s=97e4c47336c218a93c2ae3667ac878ae1a545c1b" alt="r/esProc_Desktop - Find The Differences Between Contents of Two Cells" /></p>
<p><strong>Explanation</strong>:</p>
<p>The symbol \ computes difference, which are members that are contained in set A but are not contained in set B. Symbol / concatenates two strings. $[] represents a string.</p>
<p>For more related information:</p>
<p>SPL download address: <a target="_blank" href="http://www.scudata.com/download-Desktop">esProc Desktop Download</a></p>
<p>Plugin Installation Method: <a target="_blank" href="https://c.scudata.com/article/1652061135502">SPL XLL Installation and Configuration</a></p>
<p>References to other rich Excel operation cases: <a target="_blank" href="http://c.raqsoft.com/article/1651916536524">Desktop and Excel Data Processing Cases</a></p>
<p>SPL Programming (YouTube FREE courses): <a target="_blank" href="https://www.youtube.com/playlist?list=PLQeR-IhHo7qNCw6o7PW8YfHvRx8pgzZso">https://www.youtube.com/playlist?list=PLQeR-IhHo7qNCw6o7PW8YfHvRx8pgzZso</a></p>


**Problem description & analysis**:

In the following Excel table, cell A1 and cell B1 contain strings made up of vertical line-separated numbers and walled in by vertical lines at both ends:

|  | A | B |
| --- | --- | --- |
| 1 | ｜55｜56｜60｜99｜120｜ | ｜55｜56｜62｜100｜121｜130｜210｜312｜ |

Task: find numbers that exist in A1 but does not exist in B1 and display them in the same format:

|  | D |
| --- | --- |
| 1 | ｜60｜99｜120｜ |

**Solution**:

Use ***SPL XLL*** to do this:

```plaintext
=spl("=$[|] / (?1.split($[|]) \ ?2.split($[|])).concat($[|])/ $[|]",A1,B1)
```

As shown in the picture below:

![r/esProc_Desktop - Find The Differences Between Contents of Two Cells](https://preview.redd.it/find-the-differences-between-contents-of-two-cells-v0-t4rz4uwxuked1.png?width=1053&format=png&auto=webp&s=97e4c47336c218a93c2ae3667ac878ae1a545c1b align="left")

**Explanation**:

The symbol \\ computes difference, which are members that are contained in set A but are not contained in set B. Symbol / concatenates two strings. $\[\] represents a string.

For more related information:

SPL download address: [esProc Desktop Download](http://www.scudata.com/download-Desktop)

Plugin Installation Method: [SPL XLL Installation and Configuration](https://c.scudata.com/article/1652061135502)

References to other rich Excel operation cases: [Desktop and Excel Data Processing Cases](http://c.raqsoft.com/article/1651916536524)

SPL Programming (YouTube FREE courses): [https://www.youtube.com/playlist?list=PLQeR-IhHo7qNCw6o7PW8YfHvRx8pgzZso](https://www.youtube.com/playlist?list=PLQeR-IhHo7qNCw6o7PW8YfHvRx8pgzZso)

	A	B
1	｜55｜56｜60｜99｜120｜	｜55｜56｜62｜100｜121｜130｜210｜312｜

#33 -Find The Differences Between Contents of Two Cells