Return data from Google search

[ZZZZZZZ37]

Hi All, 

I'm trying to clean my data. I was given a list of companies but they are with special characters. Is there a way to clean it or search it on google to return the correct data? Please see below.

Thank you all in advance.

Regards,

[v-yadongf-msft · Accepted solution]

Hi @ZZZZZZZ37 ,

This is my test table:

Please try:

Text.Select([Column1],{"A".."z"})

 Cleaned data:

Best regards,

Yadong Fang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.