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

Bree Salmon  Identity Verified
Japan
Local time: 13:21
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!


Direct link Reply with quote
 

Dominique Pivard  Identity Verified
Local time: 06:21
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!

Direct link Reply with quote
 
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: 05:21
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


Direct link Reply with quote
 

SEA-words  Identity Verified
English to Italian
+ ...
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.


Direct link Reply with quote
 

Dominique Pivard  Identity Verified
Local time: 06:21
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


Direct link Reply with quote
 

Grisel Cremonesi
United States
Local time: 23:21
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!

Direct link Reply with quote
 


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





PerfectIt consistency checker
Faster Checking, Greater Accuracy

PerfectIt helps deliver error-free documents. It improves consistency, ensures quality and helps to enforce style guides. It’s a powerful tool for pro users, and comes with the assurance of a 30-day money back guarantee.

More info »
Wordfast Pro
Translation Memory Software for Any Platform

Exclusive discount for ProZ.com users! Save over 13% when purchasing Wordfast Pro through ProZ.com. Wordfast is the world's #1 provider of platform-independent Translation Memory software. Consistently ranked the most user-friendly and highest value

More info »



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