So i have the following situation: I have an excel file in which i have a list of cities, but they are not entered correctly. For example, i have the city Pitesti, but in my file it can be written in different way, like Ptesti, Piitesti, Pittesti etc.
Now, it would help me to create an automation that takes into consideration all those wrong inputs and corrects them to Pitesti, the proper name.
A nudge in the right dirrection would be more than helpful.