Find and replace function

[Feras95p]

Dear all,

I have two excel files, file 1 which has multiple districts name and each district name could be written by multiple spelling ways but has only a unique xID. On the other hand I have file 2 which has only one unique spelling of each district name with the same unique xID of the file 1. What I want is that to add a new column in file 1 with a name of xName and write the unique spelling of each district name like file 2.

Any help in that please?    

[JosephSerpis · Accepted solution]

Hi @Feras95p I mocked up a workflow let me know what you think?

[Feras95p]

Hi @JosephSerpis ,

Thanks for your help!