Mobile menu

Transfer tables from Word to Excel
Thread poster: Elena Ghetti

Elena Ghetti  Identity Verified
Italy
Local time: 22:51
Member (2003)
English to Italian
+ ...
Feb 2, 2005

all works well until Excel finds a paragraph mark in a Word cell - at this point Excel creates a new cell that did not exist in the Word table so that tables do not match any more. Any suggestion to prevent this? (apart from replacing all paragraph marks)

Direct link Reply with quote
 

Jerzy Czopik  Identity Verified
Germany
Local time: 22:51
Member (2003)
Polish to German
+ ...
No, you MUST replace or NOT create additional paragraph marks in table cells Feb 2, 2005

Even manual line break (SHIFT+ENTER) causes Excel to crate a new cell.
If you copy a table from Excel to Word, all soft line breaks in Excel (ALT+ENTER) will be replaced by paragraph breaks. It is advisable either to replace thosy by a character string, which does not occur in the translation (x123z or similar), then to mark this in Trados as external TAG, translate, copy back to Excel and then search for that phrase to replace it with ALT+ENTER. AFAIK there is no automated search for this in Excel. The other possibility is to translate the Excel sheet with TAG Editor. It does recognise and keep the line breaks in Excel.

Regards
Jerzy


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 »

Transfer tables from Word to Excel

Advanced search






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 »
Protemos translation business management system
Create your account in minutes, and start working! 3-month trial for agencies, and free for freelancers!

The system lets you keep client/vendor database, with contacts and rates, manage projects and assign jobs to vendors, issue invoices, track payments, store and manage project files, generate business reports on turnover profit per client/manager etc.

More info »



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