Good day Kiran,
To manually translate, you can go to the Research task pane > select Translation > select language pair > search for a word or phrase. . A quick way to get there is to ALT-Click a cell with text you want to translate to bring up the Research pane with that text pre-entered in the search box. To actually answer your question re. using a formula or macro -- I have not the experience! . BUT, it looks like you can use the RESEARCH object in Excel 2007+ VBA (check the Help, Google, or perhaps someone else here can give you an example) . AND, here is a link to some code from Patrick O'Beirne, on his blog, for utilizing the MicrosoftTranslator.com API for free from VBA: https://sysmod.wordpress.com/2012/01/09/microsoft-translator-vba-code-sample / Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Kiran Kancharla Sent: Friday, June 15, 2012 11:44 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Translating Hi All, Request you to please let me know, is there any Inbuilt formula or a Macro to translate words in Excel. -- Thanks & Regards, Kiran -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ---------------------------------------------------------------------------- -------------------------- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
