Log In
Register
Home
December 29, 2016
Offline
Hi everyone!
I have a doubt about if exists any Excel formula to translate something for portuguese to english and spanish, for example?
Typically, when we prepare a presentation for stakeholders, is common to present in different languages, so it is very useful. Can you help me please? See attach for example.
Thanks
December 8, 2017
Offline
There is no attachment
December 29, 2016
Offline
December 29, 2016
Offline
Sorry, now I attached. I want to understand if there is any formula to convert a word for english or spanish. Or any macro to convert this.
Thanks
November 19, 2017
Offline
If you have a database like you attached, VLOOKUP may solve the problem.
VIP
Trusted Members
December 7, 2016
Offline
Hello Hava,
As Clark mentions, you can easily do such by using a list or table where you have the different words or sentences listed.
I have created a small example file for you just to show you a simple approach.
If you want to learn more then there is a nice article by Mynda here.
Regards,
Anders Sehlstedt
December 29, 2016
Offline
Hi Thanks you both!
But if I don´t have any list? I want to create a input in portuguese and automatically translate to English? Is it possible?
Thanks,
HY
VIP
Trusted Members
June 25, 2016
Offline
Hi Hava
Your question is not very clear to me (maybe even to Clark and Anders).
Do you want to translate the word automatically upon entry? Do you want to translate a single word or a whole sentence? There are so many questions.
If you just want to translate just a few words (which is what we thought you wanted) then you can try using auto-correct.
You can even use the search and replace function to do that.
Excel too have a Translate option from tab Review - Translate. You can see if any of the above helps.
Since you did not provide enough info, it is very difficult to give you an answer whether it is possible or not.
I would suggest that you include an Excel attachment with enough info/data for us to see what you really wanted.
Sunny
1 Guest(s)
