+ Reply to Thread
Results 1 to 7 of 7

Translate English to French without using Google Translate

  1. #1
    Registered User
    Join Date
    04-29-2019
    Location
    Ottawa, Canada
    MS-Off Ver
    2016
    Posts
    4

    Translate English to French without using Google Translate

    Hello

    I am working on an excel document and I need to be able to translate between English and French. Because the words don't translate very well on Google, I need to create my own translations list.

    Initially I just created two master tabs in my document entitled English and the other French. I just inserted a basic if statement to my working tabs " =IF(A1="English", English!A3,French!A3)". This was a great way to replace all of the headings with either French or English. Now that the document is growing and the tabs are not all the same this is no longer a viable option. I was hoping to find a way to create a list of English and French words and depending on which language is selected, the words would be replaced.

    This is my first post ever so please bear with me if this needs more details.

  2. #2
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,403

    Re: Translate English to French without using Google Translate

    Can you attach a copy of your file and explain in detail what you want to do referring to specific cells, rows, columns and sheets?
    You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
    Practice makes perfect. I'm very far from perfect so I'm still practising.

  3. #3
    Forum Guru Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    11,641

    Re: Translate English to French without using Google Translate

    Wouldn't MSWord be a better alternative?

  4. #4
    Registered User
    Join Date
    04-29-2019
    Location
    Ottawa, Canada
    MS-Off Ver
    2016
    Posts
    4

    Re: Translate English to French without using Google Translate

    Hi Mumps and Pepe Le Mokko,

    I work in budgets so I have various headings that need to be translated however the bulk of my document is calculations. I agree if it were just writing ms word would be better however, I need all my formulas. I used to work with SharePoint and they had a functionality to allow you to create a translations list and then click the preferred language. Was hoping for something similar here.

    Mumps, I am working to create a similar document that I can post, unfortunately because of the nature of my work I cannot post my doc. Basically, I just have a bunch of headings (Region name, Total, Period, etc.) and I need the heading names to pivot between French and English depending on the user. In my original document, there were 30 tabs that had the exact same headings. Because they all had the same look, wherever there was a title I inserted the IF statement above. Now that I've added in more things, some regions have a different look.

    I was thinking I could do something like : if French is clicked, it would look up the current word and then input the French equivalent. Does this make sense?

  5. #5
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    12,882

    Re: Translate English to French without using Google Translate

    I was thinking I could do something like : if French is clicked, it would look up the current word and then input the French equivalent. Does this make sense?
    That sounds like a good approach to me. Is there a specific part of implementing something like this that you have trouble with? I would expect to try something like:
    1) Have a cell with a dropdown/data validation that accepts either French or English.
    2) Have a lookup table with the different words. (Being anglocentric, I would put the English word as the lookup value, but there's no reason it could not be the other way around):
    Please Login or Register  to view this content.
    3) A lookup function like =VLOOKUP(english word,lookup table,IF(language dropdown="French",2,1),False)

    Can you make something like that work for you?
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  6. #6
    Registered User
    Join Date
    04-29-2019
    Location
    Ottawa, Canada
    MS-Off Ver
    2016
    Posts
    4

    Re: Translate English to French without using Google Translate

    Thanks MrShorty!

    That works well with most cells however, with some of the new tabs I have tables. I don't think I can insert a formula for a table heading, can you think of a way around this?

  7. #7
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    12,882

    Re: Translate English to French without using Google Translate

    I never work with tables, so I don't know how to really work with them.

+ 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. Macro: translate text from cell using google translate
    By Marc_excel_tips in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 01-05-2021, 06:18 AM
  2. Translate text from cell using Google translate (2)
    By Andreea1234 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-31-2019, 07:36 AM
  3. Replies: 3
    Last Post: 04-29-2016, 04:10 AM
  4. translate to english
    By Baskar5353 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-29-2015, 09:40 AM
  5. 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
  6. [SOLVED] Translate Yes/No message Box to French
    By ahng in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-28-2012, 10:38 AM
  7. [SOLVED] Translate formula to english
    By Mendz5 in forum Excel General
    Replies: 4
    Last Post: 08-23-2006, 09:49 AM

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