In this tutorial, I will show you how to create a custom function using VBA to identify duplicate text strings in a sentence. Here I take an example of addresses, where the city or area name has been repeated by mistake. The VAB custom function quickly gives you TRUE if there are duplicates and FALSE if not.