How to check for duplicates in an excel cell?

Question

excel

Hello. There is an Excel cell with some text, for example:
#Test#PodTest#PodPodTest#Test2#PodTest2#PodPodTest2#Test#PodTest#PodPodTest Phrases

are repeated here: "#Test#PodTest#PodPodTest#" How can I track this and somehow notify user, let's paint or ideally remove a duplicate. The main question is how to find it, I'll do the rest. Thanks in advance

Answer 1

FIND or SEARCH functions and conditional formatting.