VBA find duplicates

[Jeffreyxx01]

Hi,

is there a way to find duplicates and highlighted them without using the conditional formatting?
Like I use conditional formatting for the simple find duplicates but where some of my duplicates have more words in the cell but are still duplicates with the 2 first words,

For example, I would have in column C:

Aero tech
Aero technology Ltd,

Those are duplicates for sure,
Is there a way of having a macro?

 

[mse330]

Would matching the "first" word only be sufficient or it would still create issues ?

 

[Jeffreyxx01]

Matching first word would not be sufficient, assuming the full cell looks like this: A.Detroit and there is another one with A.Chris, it would become quite difficult to have a good match?

 

[mse330]

For the given issue/example above ("Xiros Limited" & "Xiros Ltd"), there's only one word matching. I am not really sure if I can help further with this request. Perhaps some other members have alternative ideas/suggestions to support