Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
3 years ago

Replace values

I have a column with the name of cities, but these are written differently, that is, there are grammatical errors. I need to be able to make a filter where I can select multiple city fields and replace them with the correct name.

Example annex for better illustration

Current Correct

BogotaBogota
boogotaBogota
BogottaBogota
BoogotsaBogota

Logically there are many more misspelled cities and I need to normalize the column with the correct values. How do I do this in Power Query? Thank you

2 Replies

    • Syndicate_Admin's avatar
      Syndicate_Admin
      Administrator
      3 years ago

      Thank you very much for the answer, however, this solution would serve me in the case that I previously knew how the city is written, but I do not know that until I make the filter and be able to select the ones I want to change.

      Therefore what I require is that once I have selected the rows that contain the value I need through a filter, to be able to change them to the value I need, Thank you