Translating Excel files - putting target into adjacent cell Автор темы: Bree Salmon
|
|---|
Bree Salmon 
США
Local time: 14:05
японский => английский
I am wondering if there is any way to have Wordfast Pro automatically put target segments into cells one cell to the right of the source?
To explain in more detail:
1. I have an Excel file with two columns, column A and column B.
2. The source language sentences are in column A, and I would normally type in the English translation in column B.
3. Using Wordfast Pro, when I save the translated file, I want the target segments to not overwrite the source seg... See more I am wondering if there is any way to have Wordfast Pro automatically put target segments into cells one cell to the right of the source?
To explain in more detail:
1. I have an Excel file with two columns, column A and column B.
2. The source language sentences are in column A, and I would normally type in the English translation in column B.
3. Using Wordfast Pro, when I save the translated file, I want the target segments to not overwrite the source segments in column A, but instead be put into column B, next to their source sentences (which are in column A).
I hope I have made this clear - please let me know if I haven't!
I know that I could just copy and paste back in the column with the source sentences later, but the trouble is I only need to translate some of the rows, and need to preserve some markings that have already been made in column B.
Thanks in advance for any input! ▲ Collapse
| | | | | Advanced wizard | Jun 20, 2012 |
You can do this with the advanced wizard, which will let you specify what column you want to translate and where you want the translations to be put. It's really easy to use, just try it!
| | | | | Post removed: This post was hidden by a moderator or staff member because it was not in line with site rule | | use formulas in excel? | Jun 20, 2012 |
If you are a bit familiar with formulas in Excel, it is pretty easy to write a formula that automatically copies content from cells in row A to cells in row B if the cell in row B is empty. That way you get a complete row for translation and will not have to manually copy and paste, or use another tool.
kind regards,
Ulrika Månsson
| | |
|
|
|
pcs_MCIL
английский => итальянский
+ ...
| Non need to use formulas | Jun 20, 2012 |
Non need to use formulas, just do as Dominique suggested.It's a great thing and makes me save lots of time.
One thing they could improve: if your workbook as more than one sheet and in all of them you have to insert the translation in a given column, you have to set it up for each sheet in the wizard.
So, I'd suggest WF programmers to enable an "aplly to all sheets" feature.
| | | | | | | New video showing how to use the advanced wizard | Jul 25, 2015 |
Thank you very much for the video, Dominique!
| | | | To report site rules violations or get help, contact a site moderator: You can also contact site staff by submitting a support request » Translating Excel files - putting target into adjacent cell | Protemos translation business management system | Create your account in minutes, and start working! 3-month trial for agencies, and free for freelancers!
The system lets you keep client/vendor database, with contacts and rates, manage projects and assign jobs to vendors, issue invoices, track payments, store and manage project files, generate business reports on turnover profit per client/manager etc.
More info » |
| | Anycount & Translation Office 3000 | Translation Office 3000
Translation Office 3000 is an advanced accounting tool for freelance translators and small agencies. TO3000 easily and seamlessly integrates with the business life of professional freelance translators.
More info » |
|
| | | | X Sign in to your ProZ.com account... | | | | | |
Login to reply/comment 
Translation news related to Wordfast
