+ Reply to Thread
Results 1 to 6 of 6

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

Hybrid View

  1. #1
    Registered User
    Join Date
    04-15-2013
    Location
    Mumbai
    MS-Off Ver
    Excel 2013
    Posts
    4

    Post 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

  2. #2
    Forum Expert kersplash's Avatar
    Join Date
    11-22-2016
    Location
    Perth
    MS-Off Ver
    Home 2016 (Windows 10)/Work 2013 Pro Plus (Windows 10)
    Posts
    2,012

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

    Maybe this?

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

  3. #3
    Registered User
    Join Date
    04-15-2013
    Location
    Mumbai
    MS-Off Ver
    Excel 2013
    Posts
    4

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

    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

  4. #4
    Forum Expert kersplash's Avatar
    Join Date
    11-22-2016
    Location
    Perth
    MS-Off Ver
    Home 2016 (Windows 10)/Work 2013 Pro Plus (Windows 10)
    Posts
    2,012

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

    Post your workbook with a sample of your data.

    Go Advanced -> Manage Attachments -> Upload

  5. #5
    Registered User
    Join Date
    04-15-2013
    Location
    Mumbai
    MS-Off Ver
    Excel 2013
    Posts
    4

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

    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
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    04-15-2013
    Location
    Mumbai
    MS-Off Ver
    Excel 2013
    Posts
    4

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

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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 3
    Last Post: 04-29-2016, 04:10 AM
  2. [SOLVED] Function to Translate to other languages
    By naveenmarapaka in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 11-11-2014, 06:15 AM
  3. Sample Translate English to Arabic Text Using MS Translate
    By pidyok in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-21-2013, 08:18 AM
  4. Macro to translate from X languages to english
    By Kiran Kurapati in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-07-2013, 05:48 AM
  5. Mac 2011 excel, need to translate column of over 1500 entries from Arabic to English
    By smarttech in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 05-09-2013, 06:12 PM
  6. How to translate excel function names from english to local langua
    By Carsten T N in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-15-2006, 07:10 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1