Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
translation in Excel 2003
I have a column with text values in a foreign language. Is there a way I can
translate this text to English using a formula / macro / web query such that all translated values get populated in the adjacent column? Thanks in advance. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
translation in Excel 2003
Are the text values made up of single words or phrases? Do you have a
lot of them? You could set up a table which shows the foreign words in one column and the translation in the next column and then use VLOOKUP from that table. Hope this helps. Pete On Oct 22, 6:39*am, Shadab Malik wrote: I have a column with text values in a foreign language. Is there a way I can translate this text to English using a formula / macro / web query such that all translated values get populated in the adjacent column? Thanks in advance. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
translation in Excel 2003
Dear Pete,
Thanks for your reply but I want the kind of table that you propose to use VLOOKUP from. I have phrases in a column and need translation for those in adjacent column. I dont have any other table with such translation to use. I am looking for an inbuilt translation tool in Excel. The language that needs translation is Chinese. Thanks "Pete_UK" wrote: Are the text values made up of single words or phrases? Do you have a lot of them? You could set up a table which shows the foreign words in one column and the translation in the next column and then use VLOOKUP from that table. Hope this helps. Pete On Oct 22, 6:39 am, Shadab Malik wrote: I have a column with text values in a foreign language. Is there a way I can translate this text to English using a formula / macro / web query such that all translated values get populated in the adjacent column? Thanks in advance. . |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
translation in Excel 2003
I'm not aware of any inbuilt translation tool in Excel, so you will
need to build one yourself. Pete On Oct 22, 11:06*am, Shadab Malik wrote: Dear Pete, Thanks for your reply but I want the kind of table that you propose to use VLOOKUP from. I have phrases in a column and need translation for those in adjacent column. I dont have any other table with such translation to use. I am looking for an inbuilt translation tool in Excel. The language that needs translation is Chinese. Thanks "Pete_UK" wrote: Are the text values made up of single words or phrases? Do you have a lot of them? You could set up a table which shows the foreign words in one column and the translation in the next column and then use VLOOKUP from that table. Hope this helps. Pete On Oct 22, 6:39 am, Shadab Malik wrote: I have a column with text values in a foreign language. Is there a way I can translate this text to English using a formula / macro / web query such that all translated values get populated in the adjacent column? Thanks in advance. .- Hide quoted text - - Show quoted text - |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
translation in Excel 2003
If you go to "Research" -- "Language", you get reference books that serves
this purpose. I am not sure if this problem can be solved in Excel but I am pretty sure Excel has solution to everything ;) May be an Advanced Excel user could throw some light on it. Thanks "Pete_UK" wrote: I'm not aware of any inbuilt translation tool in Excel, so you will need to build one yourself. Pete On Oct 22, 11:06 am, Shadab Malik wrote: Dear Pete, Thanks for your reply but I want the kind of table that you propose to use VLOOKUP from. I have phrases in a column and need translation for those in adjacent column. I dont have any other table with such translation to use. I am looking for an inbuilt translation tool in Excel. The language that needs translation is Chinese. Thanks "Pete_UK" wrote: Are the text values made up of single words or phrases? Do you have a lot of them? You could set up a table which shows the foreign words in one column and the translation in the next column and then use VLOOKUP from that table. Hope this helps. Pete On Oct 22, 6:39 am, Shadab Malik wrote: I have a column with text values in a foreign language. Is there a way I can translate this text to English using a formula / macro / web query such that all translated values get populated in the adjacent column? Thanks in advance. .- Hide quoted text - - Show quoted text - . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
French to English translation of the name of an excel function | Excel Discussion (Misc queries) | |||
Translation error - Export Excel to Outlook (Contacts) | Excel Discussion (Misc queries) | |||
Language Translation in Excel | Excel Discussion (Misc queries) | |||
Excel 4 macro to VBA translation | Excel Discussion (Misc queries) | |||
Translation: .123 file extension to Excel 2003? | Excel Discussion (Misc queries) |