Translating Excel files - putting target into adjacent cell
Thread poster: Bree Salmon

Bree Salmon  Identity Verified
Japan
Local time: 22:12
Japanese to English
Jun 20, 2012

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!


 

Dominique Pivard  Identity Verified
Local time: 15:12
Finnish to French
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

Ulrika Mansson
Local time: 14:12
German to Swedish
+ ...
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


 
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.


 

Dominique Pivard  Identity Verified
Local time: 15:12
Finnish to French
New video showing how to use the advanced wizard Jun 23, 2012

Dominique Pivard wrote:
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!

I just published a video showing how to do it:

http://wordfast.fi/blog/cat-tools/2012/06/24/translating-an-excel-column-without-replacing-the-original-column/

or

http://youtu.be/9UsPYscWH5A?hd=1


 

Grisel Cremonesi
United States
Local time: 08:12
Member (2013)
English to Spanish
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

Advanced search


Translation news related to Wordfast





WordFinder Unlimited
For clarity and excellence

WordFinder is the leading dictionary service that gives you the words you want anywhere, anytime. Access 260+ dictionaries from the world's leading dictionary publishers in virtually any device. Find the right word anywhere, anytime - online or offline.

More info »
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 »



Forums
  • All of ProZ.com
  • Term search
  • Jobs
  • Forums
  • Multiple search