Fóruns técnicos » Office applications »
Excel: making dictionary
Tópico cartaz: Hikonishi (X)
Hikonishi (X)
Hikonishi (X)  Identity Verified
Estados Unidos
Local time: 00:58
inglês para japonês
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 languag... See more
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. ▲ Collapse
 
Hynek Palatin
Hynek Palatin  Identity Verified
República Tcheca
Local time: 07:58
inglês para tcheco
+ ...
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.
 
Hikonishi (X)
Hikonishi (X)  Identity Verified
Estados Unidos
Local time: 00:58
inglês para japonês
CRIADOR(A) DO TÓPICO
Works well Aug 12, 2006

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


To report site rules violations or get help, contact a site moderator:

Moderador(es) deste fórum
Maya Gorgoshidze[Call to this topic]
Prachya Mruetusatorn[Call to this topic]

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

Excel: making dictionary






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 Trados, MemoQ, Wordfast & major CAT tools. Download and start using CafeTran Espresso -- for free

Buy now! »
Trados Business Manager Lite
Create customer quotes and invoices from within Trados Studio

Trados Business Manager Lite helps to simplify and speed up some of the daily tasks, such as invoicing and reporting, associated with running your freelance translation business.

More info »