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

Bree Salmon  Identity Verified
Japan
Local time: 16:25
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: 10:25
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: 09:25
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: 10:25
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: 03:25
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





CafeTran Espresso
You've never met a CAT tool this clever!

Translate faster & easier, using a sophisticated CAT tool built by a translator / developer. Accept jobs from clients who use SDL Trados, MemoQ, Wordfast & major CAT tools. Download and start using CafeTran Espresso -- for free

More info »
SDL Trados Studio 2019 Freelance
The leading translation software used by over 250,000 translators.

SDL Trados Studio 2019 has evolved to bring translators a brand new experience. Designed with user experience at its core, Studio 2019 transforms how new users get up and running and helps experienced users make the most of the powerful features.

More info »



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