Hi team,
So I found this super great function to translate copy in Excel using
I found all "source" and "target" languages on a google translate page. If I want to translate from, let's say, English to German, the formula would look like:
This works well, however, it only works if "en" and "de" are "hardcoded" in the formula. If I use a variable here it doesn't work, even if those cells contain "en" including the quotation marks. I've also tried to use & to append the quotation marks before and after the referenced cell, but that doesn't seem to work either.
Is there anyone who knows how to tweak this code so I can reference a cell for the "en" and "de" values?
Thanks so much!
Bookmarks