1. K

    Translate texts in Excel

    Hi I'm trying to find a way to automatically translate texts in Excel, but none of the functions I have found work. The company where I work seems to have many security levels so that's why I have limited options. I already tried the following ones: *Add-ins-> Blocked by the company *Google...
  2. C

    Create term base from large data set

    Hello, I am stuck trying to solve what may be a very simple problem. I understand logically what needs to be done I just don't have the knowledge for the best way to handle this much data and not make excel crash. I am currently limited with no access to utilize Pandas to solve this even...
  3. smozgur

    Translate to Multiple Languages with Power Query - Part 3

    In the previous article of this series, Power Query vs. Google Translation API - Part 2, we discussed how to make more effective Google Translation API calls by combining all rows as a whole text with a delimiter and send it to the web server in a single batch. In this last article of the...
  4. E

    Office 2019 worth it?

    I'm thinking of upgrading from Office 2010 to 2019. I need to know if I'll still be able to read and edit docx / docm and xlsx / xlsm files created with Office 2010 read/edit in Office 2019 and files created in Office 2019 (Except new funcitons, of course) read/edit in Office 2010, without any...
  5. G

    Code to translate all workbook based on translation table

    Hi all, I have a Workbook with one sheet called "Translation" with a translation table. There are 1.300 rows in this table, with words translated from English to Spanish, starting in cell "A1" <tbody> English Spanish Assets Activo Liabilities Pasivo </tbody> What I need is a code that...
  6. M

    VBA String color built based on value

    Hi, I am working on a translation of part numbers from provider's to my company's standards. Provider's part numbers contain several words/numbers divided with spaces (all in one cell) - and my code translate them word by word by using vlookups from other sheet. So, the part number (product...
  7. N

    Spanish Translation

    Hi there - could someone please tell me whether it is possible in Excel 2016 to have English words in say column A and a Spanish translation row by row in column B? I presume it probably isn't possible as I can't see anything about it in help.
  8. T

    Sumifs based on data range and time

    Hi All So after lots of hurdles getting a new report sorted based on a data dump from a translation tool (over 50,000 rows per month) I've managed to get through pretty much every hurdle but this one. I can sum the number of words against each language, budget etc including a date range...
  9. K

    Translation reserve - balance sheet

    Hi my problem is Translation reserve in balance sheet and how to put it in powerpivot. I am consolidating a group of 10 subsidiaries and some have different functional currencies. I need to translate the balance sheet accounts to FX rate at the last day of the month and the P&L accounts to...
  10. M

    Advanced VBA macro tools

    Hi everyone, I am a translator dealing on daily basis with several excel files which share almost the same structure and I am trying to come up with a series of advanced macros that can automatize multiple and redundant tasks I have to perform in each of them. Unfortunately, my knowledge of...
  11. T

    Help: extract online dictionary to excel

    Hi I am wondering if there is a way with VBA to extract words from online web dictionary in two languages the word and its meaning with all of the pages into microsoft excel , Is there a code or can someone make it please :( Example of site :
  12. A

    Sentence translator in Excel

    Hi Folks, Here is a macro for word to word translation. Sub macc() Dim d() As String Dim myValue As Variant myValue = InputBox("Input Cell ID") d = Split(Worksheets("Titles").Range(myValue).Value, " ") For Each i In d a = Application.WorksheetFunction.VLookup(i...
  13. D


    Hi, I am new in this forum, but have monitored long time and have become a big fans of it. This forum had helped me a lot in vba excel problems. However this time I couldn't find any answer for my new issue to use I have function which work perfectly with google...
  14. H

    HELP!!??? Language Translations built into Excel

    Hi there, I am COMPLETELY new to this board, and still a noob on most features in excel.. I came across this document: EASC_audit_Questionnaire.xls and would like to know if anyone can help me with understanding the "LANGUAGE" macro function in it. You will see there is a language selection...
  15. P

    VBA Macro to help clean up report

    I am trying to rearrange a report so it can be used in a differnt department. They only need certain information, and one column of info contains a five digit code that needs to be translated into an address. I would like to create a macro that will delete all unwanted columns, Then insert a...
  16. I

    Excel 2007 function name translations

    Hi, for people using their Excel in other languages than English - Excel 2007 functions and their descriptions in 14 languages: Why? I needed an updated look-up table because at home I'm using my Excel 2007 in Finnish and I don't have a...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back