Technische Foren » Wordfast support »
Translating Excel files - putting target into adjacent cell
Initiator des Themas: Bree Salmon
Bree Salmon
Bree Salmon  Identity Verified
Vereinigte Staaten
Local time: 01:18
Japanisch > Englisch
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 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
 
Dominique Pivard
Dominique Pivard  Identity Verified
Local time: 11:18
Finnisch > Französisch
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
Ulrika Mansson
Local time: 10:18
Deutsch > Schwedisch
+ ...
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
pcs_MCIL
Englisch > Italienisch
+ ...
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
Dominique Pivard  Identity Verified
Local time: 11:18
Finnisch > Französisch
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
Grisel Cremonesi
Vereinigte Staaten
Local time: 01:18
Englisch > Spanisch
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:

Moderatoren dieses Forums
Natalie[Call to this topic]
Marco Ramón[Call to this topic]
Prachya Mruetusatorn[Call to this topic]

You can also contact site staff by submitting a support request »

Translating Excel files - putting target into adjacent cell







LinguaCore
AI Translation at Your Fingertips

The underlying LLM technology of LinguaCore offers AI translations of unprecedented quality. Quick and simple. Add a human linguistic review at the end for expert-level quality at a fraction of the cost and time.

More info »
Pastey
Your smart companion app

Pastey is an innovative desktop application that bridges the gap between human expertise and artificial intelligence. With intuitive keyboard shortcuts, Pastey transforms your source text into AI-powered draft translations.

Find out more »