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:

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

Use SPL XLL to do this:

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

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.

Source:https://stackoverflow.com/questions/78192482/how-do-i-go-about-removing-values-found-in-one-cell-out-of-another-cell