Translate a column of supplier names to ENGLISH which are in different languages

Hi Gurus,

I am facing issues with a list I'm working on excel. One of my columns has a list of Supplier names (like 2000 or more of them) in various languages for ex: Chinese, Korean, Spanish, Potuguese, etc.
Can someone help me how can i have all of them converted to ENGLISH at a go in an adjacent column or in a new sheet?

By using a function or using VBA? Your assistance will be greatly appreciated.

Thanks,
Kumar Ph

Maybe this?

https://www.tutorialspoint.com/excel..._worksheet.htm

Hi Kersplash,

Thanks but I suppose this works only for a single cell at once or a single language translation. I have to return to each and every cell to do this. i was looking for a one-off solution for all the cells in a column at one go.

The problem is I have multiple languages in a column and not just one. Can you help me with a solution for this?

Thanks,
Kumar Ph

Post your workbook with a sample of your data.

Go Advanced -> Manage Attachments -> Upload

Hi,

I've added the example of what I am working on.
In the column A i have a series of around 2000+ suppliers in English and also in multiple languages. I want them to be translated into English in Column B. Please help me if that is possible?

Thanks,
Kumar Ph

Was anyone able to go through this? Kindly assist me please