How do I translate only non-translated cells in Excel?
Thread poster: Edward Potter

Edward Potter  Identity Verified
Spain
Local time: 17:10
Member (2003)
Spanish to English
+ ...
Oct 25, 2005

I have 2 columns in Excel. The first column has the source language. The second column is for typing in the translation. However, the second column already has some of the cells filled in with translated text.

How do I go about attacking this translation with WordFast?

Thanks in advance for any help!


Direct link Reply with quote
 

Pernille Chapman  Identity Verified
United Kingdom
Local time: 16:10
Member (2004)
English to Danish
+ ...
Work around the cells that have already been translated Oct 25, 2005

I haven't been in this situation myself, but in Excel, I usually translate directly into a copy of the source text column (although you're working in a Word file, the translated text goes directly into the worksheet). If you're working on a relatively short text, you should be able to copy only those source text cells that haven't been translated into the same column as the already translated cells. When the latter comes up in your Word file, you can then use the 'copy source' function to leave the translation intact.

Obviously, this is no good for a much longer text, so I'm keen to know if there is a better way...


Direct link Reply with quote
 

Edward Potter  Identity Verified
Spain
Local time: 17:10
Member (2003)
Spanish to English
+ ...
TOPIC STARTER
Still need a better way Oct 25, 2005

Thanks for the reply, Pernille.

I do indeed have a very large file (over 3,000 lines) and several hundred are already translated in the next column. I need a way to translate into the empty cells in the next column while leaving the cells with the translations already done alone.

Does anyone know how to do this?


Direct link Reply with quote
 

Gianni Pastore  Identity Verified
Italy
Local time: 17:10
Member (2007)
English to Italian
Use a filter... Oct 25, 2005

...on the second column only. Then choose "empty" option from the filter. This should leave you with only the empty cells. Hope this helps.
Gianni

PS Filter > Automatic Filter from the Data menu. Then click on the arrow in the second column and choose "empty"


[Edited at 2005-10-25 15:58]


Direct link Reply with quote
 

Edward Potter  Identity Verified
Spain
Local time: 17:10
Member (2003)
Spanish to English
+ ...
TOPIC STARTER
Please explain more Oct 25, 2005

Hi Gianni,

Could you be a little more specific, please? I don't quite understand how to use the filter. Is it under the Formatting menu? Do I have to select the entire column?

Thank you!


Direct link Reply with quote
 

Edward Potter  Identity Verified
Spain
Local time: 17:10
Member (2003)
Spanish to English
+ ...
TOPIC STARTER
I can't find the arrow and "empty" Oct 25, 2005

PS Filter > Automatic Filter from the Data menu. Then click on the arrow in the second column and choose "empty"

Hi Gianni,

I'm feeling kinda dumb. I did find the Automatic Filter. When you say "the arrow" do you mean select the entire column? Where do I find that arrow? And, where do I choose "empty"? Do you mean "delete" by any chance?


Direct link Reply with quote
 

Edward Potter  Identity Verified
Spain
Local time: 17:10
Member (2003)
Spanish to English
+ ...
TOPIC STARTER
I think I got it! Oct 25, 2005

Gianni, you have been a great help!

"The arrow" was a little arrow that appeared at the top of the selected column. I then selected the option "all" and it filters out (i.e. hides) all cells that has text in it. I can now go on my merry way translating all other text with WF and take out the filter when I am finished.


Direct link Reply with quote
 

Gianni Pastore  Identity Verified
Italy
Local time: 17:10
Member (2007)
English to Italian
Hi Edward... Oct 25, 2005

Edward Potter wrote:

PS Filter > Automatic Filter from the Data menu. Then click on the arrow in the second column and choose "empty"

Hi Gianni,

I'm feeling kinda dumb. I did find the Automatic Filter. When you say "the arrow" do you mean select the entire column? Where do I find that arrow? And, where do I choose "empty"? Do you mean "delete" by any chance?


as I have never used wordfast, the procedure I explained can be done in Excel (dunno about doing the same in wordfast).

1) Select the column you want to apply the filter by clicking on (say) the B letter on top of the second column.

2) On top menu, go to Data (I have Excel in Italian, and it's called "Dati") It's the menu on the right of Tools

3) Select "Filter" and then "Automatic Filter"

4) On top of the column you have previously selected, notice a popup menu button

5) Click on that button. You should see a list of option. Scroll down til you see "empty cells" (or something similar) and select it.

6) This makes the filter select only the empty cells, leaving out the one with data in.

Try this and let me know
Gianni


Direct link Reply with quote
 

Samuel Murray  Identity Verified
Netherlands
Local time: 17:10
Member (2006)
English to Afrikaans
+ ...
Reposting my reply from Yahoogroups Oct 26, 2005

Edward Potter wrote:
I have 2 columns in Excel. The first column has the source language. The second column is for typing in the translation. However, the second column already has some of the cells filled in with translated text.


The identical question was asked on the Yahoogroup, and I provided an answer (but received no reply). Does my solution not work? Here it is again:

1. Sort the columns alphabetically by the second column. This should give you all the translated rows together (either at the top or the bottom of the file). Copy only those rows with translations, and turn them into a TM. You can do this using Align in PlusTools (save the first column as source.txt, save the second column as target.txt, open both in MS Word, run PlusTools, and press the Align button).

2. Copy the source column to a new worksheet, and translate it using Wordfast, as usual, using your new TM. If you feel more comfortable working in MS Word, you can copy the column into an empty MS Word document instead, and translate it (just make sure you don't add additional line breaks).

3. When you're done, paste the translated column over the second column (it will replace everything in the second column).

If you have made changes to any of the existing translations, the above method will reflect those changes. If you want the existing translations to override any changes you've made, do this:

4. Paste the translated column into the third column instead of the second column.

5. Copy the three rows to MS Word or any other text editor that supports find/replace of tab characters. The newly translated strings will now have a double tab between the source and the target. Remove all double tabs using Find/Replace (find ^t^t, replace with ^t).

6. Copy everything back into Excel, and delete the third column.

So... does this method work?


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 »

How do I translate only non-translated cells in Excel?

Advanced search


Translation news related to Wordfast





WordFinder
The words you want Anywhere, Anytime

WordFinder is the market's fastest and easiest way of finding the right word, term, translation or synonym in one or more dictionaries. In our assortment you can choose among more than 120 dictionaries in 15 languages from leading publishers.

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

SDL Trados Studio 2017 helps translators increase translation productivity whilst ensuring quality. Combining translation memory, terminology management and machine translation in one simple and easy-to-use environment.

More info »



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