Excel: making dictionary
Thread poster: xxxHikonishi
xxxHikonishi  Identity Verified
United States
Local time: 09:50
English to Japanese
Aug 12, 2006

I have a dictionary in text file in which odd rows have source language (English) and even rows have target language (Japanese). I want make an Excel file in which the first columns have source language and the second columns have target language.

I simply copied the text file and pasted it on Excel, and made a file. Odd rows have source language in the first column and target language in the second column, while even rows have target language in the first column and source language in the second column.

Now I want to delete all even rows, and make a file in which source is in the first column and target is in the second line. How can I do this? Please advise.


Direct link Reply with quote
 

Hynek Palatin  Identity Verified
Czech Republic
Local time: 16:50
English to Czech
+ ...
Excel: making dictionary Aug 12, 2006

Open the file in Word. Select all (Ctrl+A) and go to: Table - Convert - Text to table. Set 2 columns and paragraphs as the text delimiters. Click OK and you should have your table. Then you can copy it to Excel.

Direct link Reply with quote
 
xxxHikonishi  Identity Verified
United States
Local time: 09:50
English to Japanese
TOPIC STARTER
Works well Aug 12, 2006

Thank you! Now I could get a Excel file for MultiTerm.

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 »

Excel: making dictionary

Advanced search






Across v6.3
Translation Toolkit and Sales Potential under One Roof

Apart from features that enable you to translate more efficiently, the new Across Translator Edition v6.3 comprises your crossMarket membership. The new online network for Across users assists you in exploring new sales potential and generating revenue.

More info »
SDL MultiTerm 2017
Guarantee a unified, consistent and high-quality translation with terminology software by the industry leaders.

SDL MultiTerm 2017 allows translators to create one central location to store and manage multilingual terminology, and with SDL MultiTerm Extract 2017 you can automatically create term lists from your existing documentation to save time.

More info »



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