Hi All
I am using Excel 2010. I have a sheet which has rows in Spanish(see attached). Is there any way to convert this sheet into English. I have just attached a sample version but the actual sheet consists of 78000 entries!!!!!!!! so converting each individual entry into English is not possible.
sorry, i dont believe there is any regular excel function that will do that translation for you
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
You may want to google for a VBA solution using a web service like Google translate. There are many examples to be foundOriginally Posted by kuntalnr
Complicated situation.
Not the most brilliant code ever written but it does the job. Insert a module in the workbook and copy & paste the code below into that module
Please Login or Register to view this content.
If you like my contribution click the star icon!
Dear Kuntalnr, I have not received any reaction on the solution I have build for you. Are you using it, or have I just wasted my time?
Dear OllieB, i want to use this script. please tell me how can I ? My problem is to translate arabic language in excel cell to english. Please can you explain the steps.
Welcome to the Forum, unfortunately:
Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks