How to search substring against row and if duplicates found, remove them?

Desired logic:
If O2="true" then search (substrings) in e2 against e:e and if (substrings) in e2 are found elsewhere in e:e then delete said substrings from e2, else do nothing, leave cell contents as is.

e2 looks like:

http:// ec2-54-172-158-94.compute-1.amazonaws.com/assets/images/bob/asdf1.jpg;http:// ec2-54-172-158-94.compute-1.amazonaws.com/assets/images/bob/asdf2.jpg;http:// ec2-54-172-158-94.compute-1.amazonaws.com/assets/images/bob/asdf3.jpg

I have inserted spaces after the // to preserve formatting. The semicolon ";" separates substrings. In this case, e2 has the three unique substrings of:

http:// ec2-54-172-158-94.compute-1.amazonaws.com/assets/images/bob/asdf1.jpg

http:// ec2-54-172-158-94.compute-1.amazonaws.com/assets/images/bob/asdf2.jpg

http:// ec2-54-172-158-94.compute-1.amazonaws.com/assets/images/bob/asdf3.jpg

What I do know:
1 The amount of substrings in each cell in range e:e are not guaranteed to be the same. Cells may sometimes be blank but will never exceed 12 substrings.
2)Substrings will ALWAYS start with the http:// file path up UNTIL the word "bob".

Ask any questions! Thanks! I asked over on mrexcel and couldn't find an answer. I googled but my knowledge of vba isn't sufficient.