replace text errors

[jochendecraene]

Hi

I've imported a list of names, but I get text errors. Left column are the errors, right is the correction as needed.

Can someone show me how I can solve this? 

[v-shex-msft]

HI @jochendecraene,

Did any regularly in these error text strings? If that is the case, you can create a replace dictionary table for these replacement operations:

Bulk Find And Replace In Power Query | How To Excel

If not, I think this requirement should more relate to text recognition and analysis. Maybe you can consider integrating external text analysis, AI insight, machine learning features/api to analyze values and do replacement operations.

Regards,

Xiaoxin Sheng

[amitchandak · Accepted solution]

@jochendecraene , You need to write Text.Replace

refer if this can help

https://www.howtoexcel.org/power-query/bulk-replace-values/